Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to update a form related to a table ?!?

Status
Not open for further replies.

Jonath

Technical User
Jul 13, 2007
27
FR
Hi,

I have a table named 'ENQUETEURS' and a form 'ENQUETE' with bound controls to edit/add records in the table.

Initially I had 1224 records on the table, and the form showed...1224 records

BUT I copied/pasted an updated version of the table with 1297 records, and the form still shows 1224 records (whereas I have no problem with the table).


Anyone knows how I could update the listing of the form?!?

I can still navigate through the old 1224 records with the form, but can't access the new ones.

Thanks in advance.
 
Does the new table have a different name?

If so, go to the form properties (click the box at the top left of the screen), go to the data tab and change the Record Source to the new table.

John
 
Thanks for answering, but I solved the problem

The form was actually bound to 2 tables with a common field, and I didn't update the second table :p
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top