form not displaying records

[hayden]

Hi on my data base i have a customer form which when opened doesnt bring up the records, it used to and its record source is tbcustomer any ideas, i have attached it aswell thanks

 

[JamesMcS]

That is weird isn't it? I can't see the problem... Er, does a new form based on that table pull the records back?

As an aside if you post a DB, good idea to take personal data out and put some test data back in, unscrupulous types out there on t'interweb...

 

[hayden]

good point and no if create new form works perfectly maybe have to do that after all not a complex one

 

[Mr. B]

hayden,

If you are talking about the "ABC Bounceers New Customers" form, then the problem is that you have this form setup to do new records only. If you look at the properties for this form, you will see that you have the "Data Entry" property set to "yes". If you change this property to "No" all of your recors will display.

 

[hayden]

ahhh thank you your a life saver

 

[Mr. B]

Glad to help. If I helped you out, you can click on the scales icon at the upper right to help me and my reputation.

 

[hayden]

i have done it

 

[JamesMcS]

Ha well spotted Mr. B! Totally missed that one...

Cheers for the rep hayden