Write "Edit List Items.." data back to original form.

[ngahm]

This should be easy, but I have not been able to figure it out. I have created a data entry form with several fields that are foreign keys linked to primary keys in appropriate information tables. I have succesfully linked to the various table and displayed information fields (rather than key numbers) in comboboxes in the data entry form. This works perfectly to lookup and enter the proper value from the appropriate table.

If the value is not in the appropriate table, I have successfully created the ability go to a data entry form for that "appropriate table" (by right clicking the combobox and selecting "Edit List Items...") and enter the new value. Now, here is my problem; when I close the "Edit List Items.." form and return to the original data entry form, I would like to have the field, in the combbox of the original data entry form, populated by the newly entered data. This is what I think should be easy, but I have not been successful. Any help would be appreciated. Thank you.

[aytee111]

OnClose - Forms!formname!comboboxname.requery

If this doesn't work then maybe the new data hasn't been saved yet. You may need this:
If Me.Dirty Then DoCmd.RunCommand acCmdSaveRecord

[ngahm]

Thank you, aytee11, for your prompt respone. I entered "Forms!formname!comboboxname.requery" (with appropriate formname and comboboxname substitutions) in the OnClose option of the lookup form as a VB expression and get the following: "error '438' Object doesn't support this property or method". I also tried it as expression with the Expression Builder, and it did not work. What am I doing wrong?

[aytee111]

The form is open, I presume?

[ngahm]

Yes, it is.

[aytee111]

Try putting it in the form's AfterUpdate.

Or close the original form and OnClose re-open it.

Sorry, I thought this would be a simple one!

[ngahm]

Putting Expression in AfterUpdate gives same error message as when expression is in OnClose. Closing form and then reopening it does not work either.

Although we have not yet come up with an answer, I appreciate your help.

[aytee111]

I'm trying to mess around with something, but no luck so far. Maybe you should start another thread with a slightly different subject, maybe someone cleverer will know the answer!

[aytee111]

Closing and reopening the form worked for me. When I opened form 2 I closed form 1, then when I closed form 2 I opened form 1 and the new value was in the combo box.

[ngahm]

Hello again aytee11:
If it helps, the foreign key in the original form refers to a lookup query so that the field in the form (and in the dropdown box) displays the field information rather than the key number.

[ngahm]

That's "record information field" not "field information".

[aytee111]

Here's one - OnMouseDown of the combox box put Me!ComboxBox.Requery.

i don't know how a user will be accessing the field, however, this works when I click on the down arrow. If they just start typing in the box you may have to do something else.

[aytee111]

I have to admit I don't use table lookup fields, I prefer to control the querying myself.

Old programmer!

[ngahm]

I presume the OnMouseDown statement goes in the lookup form not the original form. If that's correct, nothing happened.

[aytee111]

No, the original form. So that it requeries itself as soon as you click on the down arrow.

I wasn't bothering with the second form, I was adding records to a table manually and then trying out the combo box. I was just going through all of the events to find one that would work!