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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Two identical tables, need button on form to switch between them

Status
Not open for further replies.

SeaweedOPM

Technical User
Nov 19, 2004
53
US
I have two tables that are almost identical. The thing is that I want to use one form with a button or dropdown list to change the forms underlying table. All of the columns are named the same.

Basically it was created this way because one table contains around 2,000 records of potential customers that we need to contact back. The other table is set up to enter in the same info when a customer calls us.

I could use one table for this and just use a column that contains identifying information. The problem is that I don't want to alow changes to the existing list plus the setup for filters and the code i have remembering the last used record would not work right.

please let me know if there is a variable that i can use in the textbox's source to be changed upon the after update of a drop down menu or anything for that matter.
 

Create a button. Then add VBA code to change the form's record source then requery.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top