Change table on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is if possible to put a button on a form that would change the table the
current form answers to?
 
Yes. All you need do is change the form's RecordSource property.
 
I know I can change it in the design of the form manually. How can I do that
with a button? Can you show me an example?

Thanks.
 
Private Sub MyButton_Click()

Me.RecordSource = "SELECT Field1, Field2, Field3 FROM Table1"

End Sub
 
The assumption is that if you change the record source of the
form/subform the "names" of the fields in the two sources must be
identical for all of the fields showing on the form/subform.


Ron
 
Definitely.

To be honest, I find the idea that a form can be used with different tables
a little suspect: it makes me think that the tables are properly normalized.
I suppose, though, that there could be legitimate reasons.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
Update Two Tables Using One Form Contents 0
Hiding a button based on a value in a table 1
Prevent Duplicate Form Entries 0
Access Form Refresh 1
Data entry to table from a form 1
Populate a field on a form 0
Form for Parts-Tools Lists 0

Back
Top