Problem with Combo box Wizard

[DavidN]

I am trying to use the Combo box wizard to set up a seach of my form.

When I click on the combo box tool icon, with the button wizard selected when I place the combo box in the form, I only get 2 options. I do not get the third option that allows me to set up the combo box and search my form for the appropriate record. Option 3 is Find a record on my form based on the value I selected in my list box/combo box.

I am using Access 2007. Anyone else have this problem or have a suggestion for correcting it.

I am not experienced with coding etc, hence I was using the wizard.

Thanks
David

By the way these forums are great, I have built a database on what I have read and learnt, and hopefully can help some newbies in the future

 

[pbaldy]

You only get the third option when the form is bound to a table/query.

 

[DavidN]

What does bound to a table mean.

The form is currently used to input to a table. Would I need to set up a form that reads from a table and then I could search that. Thanks for your quick response.

 

[pbaldy]

It means the form has a table/query in its Record Source property.

 

[DavidN]

The record source propert for the form currently states select customers which is the table of the customers, which is where the form input too. Does that make sense, what would I need to change.

Thanks
David

 

[pbaldy]

Brief testing shows that if the form is bound to the table, you get the third option. If it's bound to an SQL statement (SELECT...) then you don't.

 

[DavidN]

I am a little confused now. How can I set up the link from the form to the table, without it including the select statement, as it just seems to do this automatically.

Thanks
David

 

[pbaldy]

During my test, I simply chose the table from the dropdown list. It will create a query if you click on the ellipsis (...). You would think it wouldn't matter as far as the wizard is concerned, so I'm going to poke around a little.

 

[DavidN]

What I have found, is that if you create your form using the design button, rather than the wizard it does not use the select statement, and you can link to the Custome table, and option 3 will appear.

My problem is, I have taken a long time to design my table, and if I remove the select statement, it breaks all the links and not sure how I fix that.

I suppose the best option is for me to recreate the relevant forms, without using wizard.

 

[tl mike]

It sounds like you are using a query and need to set the form up with just a table.
Go to the source section of the properties page and find the table that is the source for the form

Or use this in the events section of the combo you will have to change the controls PARTID and COMBO28

Private Sub COMBO28_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[PARTID] = " & Str(Nz(Me![COMBO28], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

 

[DavidN]

All sorted now. Thanks very much. I think my inexperience did not help