public variables

[zul]

Hi,
I created two forms to fill up data into two different tables. From the first form i created a public variable and copied data input as say "customer name" in it to hold it and pass it to the next form. Unfortunately when entering the next form i assigned an entry field with the variable contents it's not working. The customer name filed would be acting as a link field.



Thanks for support.

[Robeen]

You can try this to open your new form:

 
DoCmd.OpenForm "YourNextFormName", , , "FieldNameOnNextForm = '" & YourPublicVariable & "'"

[zul]

Will try it out, if you can help me out with another issue!
I need to implement a database on client. I wish upon entry for a client name lookup if it already exist.
Thanks

[Robeen]

Zul - best open a new thread for the new topic. More people will look at it.