Filter form based on combobox

[leanne123]

This is a simple process yet I cannot get it to work. I have a table called IDD185 which contains a PK field called 'IDOC NO'.

I created a form based on this table called frmIDOCmain. I created a combobox called [cboIDOC] based on the field [idoc no] on this form. Now when I select an idoc no. from this combobox, I want to form to move to the correct record.

Please help. I have searched the forum and other posts are much more complicated then my issue.

 

[SoCalAccessPro]

Base the form on a query.

In the query, have this criteria in the [idoc no] field:

= forms.frmIDOCmain.cboIDOC

On the combo boxes after update ecent, include the following:

me.requery



Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[GingerR]

You should have a combo box that does NOT have a control source do this. otherwise you are picking a different IDNumber that will fill into your table.

So on your form, pick Combo Box from the tool bar and put it on the form. When the wizard comes up, pick the third choice ("go to a record in the table") or whatever it says. This will be a separate combo box and not have any control source.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[leanne123]

Thanks! I went with the combobox wizard and works great.