0 Records Displayed

[Dominic84]

I've created a form for entering data. It works fine and as you enter each record the bit at the bottom says 'record 1 of xx' but when you close the form and reopen it, it says 'record 1 of 1'

I know it storing what i enter in the right table, so why isn't it reading it back???

The following might make it easier to provide answers:

The 'record source' is:

SELECT [Faults].[Stove Type], [Faults].[Rec By], [Faults].[Invoice Number], [Faults].[Serial Number], [Faults].[Date of Purchase], [Faults].[Date of Installation], [Faults].[Installed By], [Faults].[DAccountRef], [Dealers].[Name], [Dealers].[Address], [Dealers].[Contact], [Dealers].[Tel Number], [Customer].[Name], [Customer].[Address Line 1], [Customer].[Address Line 2], [Customer].[Post Code], [Customer].[Tel No], [Customer].[Fax], [Faults].[Date], [Faults].[Passedto], [Faults].[Actionreq], [Faults].[FOC], [Faults].[ActionDone], [Faults].[Completed], [Faults].[DateC], [Faults].[SO], [Faults].[test], [Faults].[test2] FROM (Dealers INNER JOIN Faults ON [Dealers].[Account Ref]=[Faults].[DAccountRef]) INNER JOIN Customer ON [Faults].[ID]=[Customer].[ID];

It has a drop down list box for selecting an account refference which then fills out the address and name text boxes.

Also there a two combo boxes that are synched with each other so that you can select a category and then a subcategory.

 

[ColinEssex]

I may be totally on the wrong track here but, it seems you have a couple of tables where the data is coming from via a query.

It may be that if you're not filling in all the fields for each table then it won't link, therefore it won't return any records.

As I say I may be totally up the wall here but perhaps someone else may be able to offer another angle.

Col

 

[Dominic84]

hmmm I just tryed fillin out all the fields and it didn't seem to make any difference...

Its wierd how it says '1 of how many you've entered' whilst the forms open but as soon as you close it and the reopen it thinks its back to '1 of 1 records'

If someone can help me fix this you'll be makin my day! 'cos i've got know idea whats going wrong.

Unless - would it have anything to do with my synched combo boxes?

 

[ColinEssex]

If you recreate the query in the query grid exactly as you have it in the form - will it return any records?

Col

 

[Dominic84]

Thanks for the quick reply

Just to clarify what you mean - you think I should:

Go into the forms record source property, delete what's there and then go into the Query Builder window and put it back in like it was before?

 

[ColinEssex]

Not really - I was trying to assertain if you created a normal select query (nothing to do with the form) that is identical to what your form is based on and just run it cold - what result do you get?

Col

 

[Dominic84]

Ahhh I c

yeah I just tryed that, went into the Query Builder and Saved what was there as a new query - ran it and it displayed a table view with a single blank record

Just like what my forms doin?

Does this mean you know what's wrong?

 

[ColinEssex]

Not really, but it proves that the links in the tables are preventing the data being shown.

Maybe the links should be the "Show all in Table1 and only those in table2 where fields match" instead of the "only match all tables" like you seem to have.

Col