Pop-up form not updating the record

[George Too]

Hi all,
A db shows its records in a subform from where I click a field to edit the contents of that field in a pop-up form (see pic). All works well except when the field contains no data. The pop-up opens blank (because there is nothing in that field) but will not update the field with typed data once the form is closed.

The only button on the pop-up form contains code that prompts the user to update the record or not.

Any ideas as to why?

Thanks,
George Too

 

[CyberLynx]

What are you using in the pop up form to update the SubForm or Table? A UPDATE query?

Perhaps try refreshing or requerying the SubForm when the pop up Form closes:

Forms("MainFormName")("SubFormName").Refresh

.

 

[George Too]

I am using a query. The form is a bound form. I have tried refresh but still no update. What I don't understand is the fact that it works with non-null records. Also, I have 2 text boxes in the form that get their data from the same query and those get their data only when the field in question is not null.

Any other ideas?

Thanks,

 

[CyberLynx]

Without actually seeing the complete connection between all the Forms, the only thing I can think real quick here George would be to refire the The SubForms RecordSource property. See what happens then.

.