Two tables, one form for dataentry, but sometimes getting error 3101?

[MedMos]

Hi all! Still an amateur at access...
I have two tables, tblObject and tblPlace, linked by a one-to-many relation (one place can have many objects). FrmObject is for registering objects, and have a textbox for entering the placename. If the placename is unknown in tblPlace, frmPlace opens for registering the new place, and then closes. But unless I then enter the placename in the textbox in frmObject again (even though it is still there!) I get an error 3101 when trying to save the record. I am stumped, is there some way to requery a textbox or getting the form to recognize the text in the box?



Many thanks.

[June7]

You say textbox but do you mean combobox?

You are using the NotInList event of combobox to add new tblPlace record?

The combobox must be requeried so its list is updated with the new record.

Use: Response = acDataErrContinue

Review:
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx
http://www.blueclaw-db.com/access_no...ed_example.htm

[MedMos]

No, it is just a textbox (bound of course), using an AfterUpdate to check tblPlace (If IsNull(tblPlace.Name) then Open Form). It all works, except I'll have to re-enter the name in frmObject to have it recognize there is a matching record in tblPlace, else I get the 3101.

[June7]

Why not using combobox?

Try BeforeUpdate event instead of AfterUpdate to validate the entry.