Annoying problem acessing records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi! I'm having a problem with a single form that has subforms.

When I try to circle thourgh records an input box appears with the message
Lookup_Sh-Gen__ID.Gen_name. No matter what value I put in there it always
goes to the next record.

Sh-Gen is my table name; Gen_name is a text field; and Gen_id is the primary
key of that table.

I think the problem is on the double underscore in the message?? But I don't
have a clue where I can fix this problem

Thanks for any help
 
What is your form based off, table or query? Make sure the record sources of
your fields are correct. It sounds like it is looking for data for the field
Gen_Name. If you form is based off a query, the field might not be in the
query or the record source may be wrong.

Hope this helps.
 
It is based on a query which was not changed.

The strange thing is that once I input something in the error box and the
next record appears all information is there!!
 
I still feel it is not finding reference to a data field. Do you have any
code on this form? If you put data into the dialog box, can you see that
data then in the form? That might help pinpoint the field with the problem.
 
Back
Top