how do i set table source for a form

[Guest]

I am trying to create a form that will have two command buttons. And depnding
on which command button the user chooses, another form will open with the
data fields displayed corresponding to the table associated for that button.

 

[RuralGuy]

I am trying to create a form that will have two command buttons. And depnding
on which command button the user chooses, another form will open with the
data fields displayed corresponding to the table associated for that button.

You can either use two different forms or if you have ac2K+ then you could pass
the information in the OpenArgs argument of the OpenForm command and set your
RecordSource in the Open event of the next form.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.