Adding a new look up field

[tonytlc]

I have a table with a selection of free text and look up fields. The lookups are from other tables. I have made a form from this table and all is working OK except that I missed out a field when I made the original table. I have gone back into the table and added a new look up field from my "Counsellors" table but when I then go back to add it to the form all connection with the table is lost. When I click show existing fields nothing appears. If I try to make a new form from the edited table then, even though the table is shown it appears to have no fields. If I then go back into the edited table, delete the relationship and then delete the new field all is OK and back to normal. The missing field however is critical to the figures that are to be produced by the DB. The message I get is "The search key was not found in any record". Is there a slution to this or do I have to make a new table and form.
I am using Access 2007 n a Windows XP Pro computer and the database has been split into FE and BE.
Tony

 

[Galaxiom]

Sounds like a problem with the RecordSource SELECT statement of the form. You may be able to fix it there by editing this statement.

 

[SOS]

1. You should NOT be using lookups at table level - only at form level.

2. This is why.

3. You just need to MANUALLY add a combo box to the form as you are past the point of using the wizard.