Basing a form recorset on a user choice from previous form

[cluksha]

I m attempting to create a form that will ask the user which extate they want (via combo box, so the msgbox is out of the picture), and from that choice, open the new form that gives all the records related to the user choice, and then close the form that asked which estate.

If that made sense, I need some help.

Thanks!
Chris

Chris Luksha
Echo Web Services
Making Your Website Resound

http://www.echowebservices.com

 

[batteam]

Maybe you could put some code in the combo box's click event that has the bound value of the box provide the criteria for a query that will return the data you want for your form. That form will be bound to that query so when the form is opened, the data from you query will populate your form.

The trick is, behind the combo box click event, requery your form then open it.

Something like:

combobox_Click
yourformname.Requery
DoCmd.Close 'this closes your current form
DoCmd.OpenForm "yourformname"

Again, make your combobox bound column value for the criteria value in your form's bound query. It should populate your form after you make your combo choice and do a requery on your form. Hope this helps. Good Luck.