Must I re-create my Form?

[JulieAsking]

Hi - Because of a problem I was having it became necessary to split 1 lookup table into 3 lookup tables. I deleted the original lookup table and created the 3 new tables. Now when I try to replace the command buttons in my Form to open input forms based on the new lookup tables so I can enter new values in combo boxes, I get the msg Access cannot find the original lookup table I deleted and therefore am unable to replace the command buttons. Does this mean I have to re-create the Form? or is there a way to tell Access to forget the original lookup table?

Thanks - Julie

 

[Jack Cowley]

Not really sure what is happening here but did you make sure that the new combo boxes are based on the right table(s)? Did you try making new Command buttons to open the form(s) using the Wizard?

 

[JulieAsking]

Jack, Thank you for your prompt reply and for being willing to help a novice.

After I created the 3 new lookup tables I changed the Row Source for the combo boxes to the new tables (there are 3 separate combo boxes referring to the 3 new lookup tables). That seems correct.

Yes, I used the wizard to attempt to create new command buttons to open forms based on the new lookup tables. After I created the buttons and click on them I get "Microstoft Jet database engine cannot find the input table "name of my deleted lookup table". Make sure it exists" etc. I need command buttons as there will be lots of new values to be entered in the lookup tables down the track. Access cant get over the fact I deleted the original single lookup table.

HOpe I've helped in clarifying my problem.

Julie

 

[Jack Cowley]

Julie, we were all novices once so we are all glad to try and give back a little....

I do not know what is going on here but here is my next shot - Open the form in Design view, delete the Record Source for the form (a table or a query). Close the form and save it. Reopen it and select the table or query that you just deleted. If that does not fix the problem then my only other suggestion would be to start making a new form with just one combo box and one command button and I bet that will work. If it does then rebuild a new form. Sorry that I don't have an easier way to do it, but that is all that I can think of. Good luck!

 

[JulieAsking]

Jack - your suggestion was the perfect solution. Many thanks

Julie