forms & Tables ?

[bizlink]

I need to create a table (and of course form) that will update the
data of a combo box in another table.....


anyone?

 

[adwaitjoshi]

Did not understand what you meant. could you please be more precise?

 

[bizlink]

better explanation?

I am creating a data base with four tables.....on atleast two
of the tables I have combo boxes.......these combo boxes will
retrieve their data from another table....I want to know if
you add data to the table via a form that we are retrieving it
from will it automatically up date the data in the combo box?

Hope this helps......I sure need it!!!!!!!

 

[Pat Hartman]

If the comboboxes use a table or query as their rowsource, updates to the table will be reflected in the combo. But, not if the form that displays the combo is already open. If that is the case, the combo will need to be requeried.

 

[bizlink]

Thank you

I have never met so many selfless people!!!!!!!!!

I created the table to retrieve from and a up form
which can be accessed by a command button...

Real cool stuff......

But the pop up form shows the data and if you don't
scroll through to the end before you ad data you could end up relpacing the existing data...no biggy if this was my data base but this is for a client....it needs to be idiot proof!

How do I make the form go to the end of the data by default?

Tony