Form Subform Help (1 Viewer)

Meehphill

Registered User.
Local time
Today, 06:17
Joined
May 9, 2013
Messages
18
Hi all,

I have been at this for a few days now...

I have a form, combo box selection, when i make a selection, all the info is good on all my tabs, which holds the subform.

My issue is, on one of the subform, it's a data entry form, where I want it to be on a new record page. instead it list all records. I want my users to see a blank page, but have one field populated. is this possible?

1) blank data entry page, but with a populated field?

as u can see on my attachment.

When a CU Name is selected,

I want the (Enter Note) tab to go to a data entry or last page or new page.

* I have tried putting it to data entry form, but the CU Number will not populate....can anyone help...

Thanks Phill
 

Attachments

  • snap.jpg
    snap.jpg
    98.9 KB · Views: 54

billmeye

Access Aficionado
Local time
Today, 09:17
Joined
Feb 20, 2010
Messages
542
Phil, have you tried to set the default value for CU to [Forms]![NameOfYourMainForm]![NameOfComboBox]

It would then automatically show that value on a new record. And as you said before, set the form to Data Entry.
 

Users who are viewing this thread

Top Bottom