Please Help

[extreme]

I have created Table and Form but when I open the form it shows this #Name? where you enter data can someone explain why this is.

Thaks

 

[boblarson]

Is it a text box where you have put a calculation? Maybe you changed the controlsource instead of the name property if you were renaming the controls.

 

[boblarson]

Is your form's recordsource bound to the table or a query? Did you rename a field and forget to change the recordsource to the correct name? For example, instead of ClientName maybe it was Client Name with a space, or Client_Name with an underscore.

 

[extreme]

I have checked that here is the db

Thanks for replying

 

[boblarson]

the problem is that you have no recordsource selected in the form's recordsource properties.

 

[boblarson]

If you select your table from the drop down in the form's recordsource property you will find it all fixed. But, you should use a query instead of the table, so look here

http://www.btabdevelopment.com/main...dsourcefromtabletoquery/tabid/75/Default.aspx

to see how to change the recordsource from a table to a query.

 

[extreme]

If you select your table from the drop down in the form's recordsource property you will find it all fixed. But, you should use a query instead of the table, so look here

http://www.btabdevelopment.com/main...dsourcefromtabletoquery/tabid/75/Default.aspx

to see how to change the recordsource from a table to a query.

Thanks boblarson works a treat