Add New Customer Form (1 Viewer)

[darth sidious]

Hi

I am having problems with my frmAddCustomers. I have a qryNewUserNumber which works. I want the number generated by this query to appear in my unbound text field(txtNewNumber) on the form. Nomatter what I try it does not seem to work. I have attached my database for any suggestions. Currently I keep getting a #Name? error

Many Thanks

Darth Sidious

 

[pr2-eugin]

The Form appears to be unbound.. In other words, the Recordsource of the Form is no loner what it once was.. Try setting the Form recordSource.. and link the appropriate fields.. If the field is supposed to be Unbound, then the Field should have no control source set..

 

[darth sidious]

The Form appears to be unbound.. In other words, the Recordsource of the Form is no loner what it once was.. Try setting the Form recordSource.. and link the appropriate fields.. If the field is supposed to be Unbound, then the Field should have no control source set..

Hi Thanks for the advice, I managed to get it working by adding the following to control source for txtNewNumber:

=DLookUp("[newUserNumber]","qryNewUserNumber")

Thanks

Darth Sidious