Autofill a subform field from a main form field

ms-access forms subforms
Matt Parker picture Matt Parker · Jan 30, 2010 · Viewed 7.2k times · Source

I have a form with two subforms, both of which are continuous. Each form has a field to accept the name of the person who created the record. Almost every time, the same person will be creating all of the records, so it would be really convenient if the fields would autofill once the main record has been set.

I've tried several approaches to this, but none seem to work quite right (e.g., the first of the continuous forms won't autofill because it came into existence alongside the main record). This is Access 2003.

Thanks in advance for your help, and let me know if I can clarify the situation for you at all.

Answer

David Walker picture David Walker · Jan 30, 2010

OnCurrent, OnClick, etc...

If IsNull(Me.MyField) or Me.MyField = "" Then

  Me.MyField = Me.Parent.MyRelatedField

End If

Related questions

How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?

I have a combo box which is of a lookup type, i.e., I've selected the source to be a column from a table and am storing the selected value in another table. The table which I am looking up …

Read More
Adding a file browser button to a MS Access form

I'd like to add a "Browse" button to an MS Access 2007 form that will bring up a standard Windows file browser (as a modal window) and allow the user to select a directory. When the user OKs out of that …

Read More
MS Access Form - Enter key not moving to new line

I have an odd issue with a form I have in MS Access. For some reason, when I hit the "enter" key within a text box, the cursor moves to a different text box. What i am looking to happen …

Read More