When Button is pressed, form should open to specific record, from a combo box - HELP

[DCTerp]

Hey there,

I'm fairly new to Access programming, and I'm still learning.



Currently, I have a form that allows for viewing of a record, but not editing (frmViewProvider). A Combo box is used to chose the record being viewed. I have a button that, when pressed, I'd like to open an another form (frmEditProvider) but when pressed, goes back to the first record in the data set, rather than the record that was recently viewed. I'd like to for the button to open the record currently being shown in the Combo Box. Is there a way to do that? (I'm sure there is, I'm just not aware of it)

Thanks, all!

J.

[DCTerp]

I found this, but when I click on my button, I get a dialog box asking for a parameter:

DoCmd.OpenForm "frmEditProvider", , , "Label3 = '" & Me.SelectProvider & "'"

[kd2017]

You need to change Label3 to the name of the data field that you are searching. This is typically a unique primary key field with a numerical datatype and not a string datatype as is implied by the code you showed in post 2.

Can you post the SQL query or row source for the SelectProvider combobox as well as the table/query structure of the frmEditProvider record source?

[DCTerp]

Here's the row source for the SelectProvider Combobox: SELECT [tblProviders].[Provider ID], [tblProviders].[Business Name] FROM tblProviders;

[kd2017]

Ok, your command should look something more like this:

DoCmd.OpenForm "frmEditProvider", , , "[Provider ID] =" & Me.SelectProvider

Make sure the Combobox's Bound Column property is set to 1.

I'm still making assumptions here, I'm assuming Provider ID is numeric and that it's also available to the record source of the form. If that doesn't work we'll need to see your table/query record source for this form.

BTW, it's best practice not to have spaces in your field names. Instead of [Provider ID] and [Business Name] you should change them to [ProviderID] and [BusinessName] or [Provider_ID] and [Business_Name] or something to that effect. Also, make sure you don't use symbols in names either, just letters, numbers and underscores.

[DCTerp]

That worked! Thanks!