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.

On Sat, 21 Jan 2006 08:00:02 -0800, "Eddy" <(E-Mail Removed)>
wrote:

>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.