Form loads with no current record

[ts_hunter]

I am releatively new to Access, but have a programming background, so I bet I am just missing some small detail. I have a table Plan_Settings that I have a edit form made for (frmEdit). I have another form frmMain that lists the records and when I double click on a record I want to bring it up in the frmEdit form so I can make changes.

I did some digging here and found how to put an embedded macro on the doubleclick event. Below is the macro I have to load the record I double click on into my frmEdit. The form comes up, but there is no record loaded. Perhaps my Where Condition is wrong? Plan_ID is the primary key.

[June7]

The does look appropriate. Although not sure the first = sign is needed.

I don't use macros, only VBA which would be (assumes Plan_ID is number type):

DoCmd.OpenForm "frmEdit", , , "Plan_ID=" & Me.Plan_ID, acFormEdit, acDialog

[ts_hunter]

I don't use macros, only VBA which would be (assumes Plan_ID is number type):

DoCmd.OpenForm "frmEdit", , , "Plan_ID=" & Me.Plan_ID, acFormEdit, acDialog

Thanks for the info. I saw that command also, but couldn't get the syntax quite right. I will try the code above in the morning and report back.

[ts_hunter]

OK, I created a new form and added a double click event to run the following code:


Private Sub Plan_Name_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmEdit", , , "Plan_ID=" & Me.Plan_ID, acFormEdit, acDialog
End Sub

Now when I double click on one of my records to bring it up in the frmEdit, I get the following prompt for a parameter:

[ItsMe]

What happens when you open frmEdit in form view using the Navigation Pane? Do you get the same missing paramater message. What happens if you open the query that is the recordsource for frmEdit?

[ts_hunter]

What happens when you open frmEdit in form view using the Navigation Pane? Do you get the same missing paramater message. What happens if you open the query that is the recordsource for frmEdit?

When I open the frmEdit from the navigation pane, it comes up empty, and then I can add records. There is no Query associated for frmEdit - do I need one?

[ItsMe]

No you do not need a query. Just trouble shooting. Open your form frmEdit in design view and check the properties of the form. In the property sheet, in the Data Tab there is a field for Data Entry. If this property is Data Entry = Yes, you will not be able to use WHERE Criteria when opening. Set it to No. If it is still opening without any records showing then check the formas recordsource.

I usualy use a docmd like this to open "filtered" results. I think acFormEdit is default and is not necesary but, I do not believe it will overide the property Data Entry.

DoCmd.OpenForm "frmEdit", acNormal, , "Plan_ID=" & Me.Plan_ID

[June7]

What is the RecordSource of frmEdit?

[ts_hunter]

What is the RecordSource of frmEdit?

I created a new query that selects all the fields from Plan_Settings, that is what the Recordsource is set to now.

[ts_hunter]

I have attached a copy of the db.TESTDB.zip

[ItsMe]

You Plan_ID field is of Text data type, so the code is a little different when you concatenate text variables into your string.

DoCmd.OpenForm "frmEdit", , , "Plan_ID = '" & Me.Plan_ID & "'", acFormEdit, acDialog

Suggest using Autonumber as PK's and Long Integer as FK's

[ts_hunter]

You Plan_ID field is of Text data type, so the code is a little different when you concatenate text variables into your string.

DoCmd.OpenForm "frmEdit", , , "Plan_ID = '" & Me.Plan_ID & "'", acFormEdit, acDialog

Suggest using Autonumber as PK's and Long Integer as FK's

BINGO! Thanks so much.