error message

[ngeng4]

still didnt work. if i click the updte[new record] from the main menu, then from the updte[new record] back to main menu then click updte[all record] the form will go blank.

and let say i click the updte[all record] 1st then back to main menu then click updte[new record] both will appear data

[ngeng4]

or maybe do i need 2 form for the same thing? update [all record] and update[new record]

[ngeng4]

how? ..do i need to create 2 form?

[maximus]

add this line of code to the Main Menu Button that you have created on the tblProject Form:
DoCmd.Close acForm, "tblProject"
the problem is the form is not closing when you are going to main menu and thus when you want to open the form in the data entry mode it is not happening. This will close your tblProject form and stop what is happening now.

No need to create two forms.

[ngeng4]

it works. yahoooo!!! thank you so much

[maximus]

you posted another post about data entry form I have given a filter option check that out.

[ngeng4]

yerp. n still working on it.. thank you.

[ngeng4]

ive tried this code[the check duplicate code]. didnt work.

[maximus]

Well I have added the code in the enter data button of the Universal Form. I have added dulicate check only to Client Name option. Try entering a Client name already entered it should give you a prompt.

[ngeng4]

thank you..

[maximus]

is it working.

[ngeng4]

yerp...currently working on it..thank you so much..=)

[ngeng4]

maximus, for the data list in the universal form, can i set it to ascending order?

[maximus]

Yes just Include Order By [Field Name] in the strSQL

[ngeng4]

thank you...