Combo Box Lookup field blank.

[Robert2150]

I have a main form which has a button to View one of the Reports related to my primary table.
The View Report works fine.
On close of the Report the program returns to the Main form, and it returns to the record of the Report that was viewed with all of the data for that record showing in all of the Fields, except the Combo Box that I use to look up a record, it is blank.


Other than that, the Look Up Combo Box works fine.
How do I get the Look Up Combo Box to show the information for that look up field.
In the On Close item for the Report I have the following code to get back to the record I want to return to.

Private Sub Report_Close()
DoCmd.OpenForm "ENLARGED PROP INFO", , , "[Name]='" & Me![Name] & "'"
End Sub

Any suggestions?

Hope this makes some sense.

Robert2150

[NTC]

Under your open form command add a 2nd vba line and try to explicitly define its value i.e.
Forms![Enlarged Prop Info].ComboBoxName = (whatever is the correct reference)

[Robert2150]

Would the correct reference be the name of the Field that is shown in the ComboBox?

[June7]

What do you mean by 'Combo Box that I use to look up a record' - is this an UNBOUND combobox for input/selection of filter criteria?

Is this form used for data entry/edit? Options for display the lookup that don't require VBA:

1. another lookup combobox bound to field

2. include the lookup table in the form RecordSource and bind textbox to the lookup alias field

[NTC]

the field that the combo box is bound to - which is not necessarily the field that displays - - look at the combo box property to see its record source and which field it is bound to... typically it is bound to the first field and displays the second field but that can be changed...

so your reference is perhaps: Me.[Name] since that is what you are using to open the field - but this is only correct if that aligns to the combo box's record source and bound field (also I should point out that 'Name' is a reserved word in the Application and so developers should avoid using it as table field names....but that may be too late in your case)

[Robert2150]

What I mean is that the Combo Box is a drop down that allows the user to select a record (by name). It is an Unbound combox.

The main form is used for data entry, and editing.

To include the lookup table in the form RecordSource do I add it to the field name? e.g FieldName_TableName.

How do I "bind" textbox to the lookup alias field?

Thank you for your help.

[June7]

Including the lookup table in the form RecordSource means the RecordSource would be a query that joins tables. Do not use INNER JOIN.

Bind textbox to a field by setting ControlSource property. Set it to the field from lookup table and prevent editing by setting properties Locked to Yes and TabStop to No.