Auto named field

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a form that has a combo box that includes programs. When a program is
selected there is a command button that opens a separate form.

This second form is a continuous form that holds different items under that
specific program. Currently the user has to select the Program name
everytime they add a selection to that program on the Second page.

How can I keep the program name a constant on the second page so that the
user only has to enter the items under the program they already selected from
the first page?
I tried making the Program a text field on the second page and putting
Programlink subform!ProgramSub. down for the control source ( which is the
first page name and the combo box name for the program on the first page. I
just get the error: Name#.

Can someone help?
 
Hi Ladybug,

Either incorporate your second form into your main form as a subform,
linking the relevant fields together, or you could use the BeforeUpdate event
in your opened form to collect the Program Name from the first form and store
it in the appropriate field on your second form. The Before Update event
fires when the first character is entered in a new record.

Hope this helps.

Damian.
 
Ok, so I created a subform into the second form and that took care of one
problem,but now causes another. I now can just add fields to the program
without selecting the program each time.
However, if that program did not already have items associated with it then
the program name is blank and users are unable to select a program.

Any more thoughts? Thank you for your help!

Damian said:
Hi Ladybug,

Either incorporate your second form into your main form as a subform,
linking the relevant fields together, or you could use the BeforeUpdate event
in your opened form to collect the Program Name from the first form and store
it in the appropriate field on your second form. The Before Update event
fires when the first character is entered in a new record.

Hope this helps.

Damian.
I have a form that has a combo box that includes programs. When a program is
selected there is a command button that opens a separate form.
Click to expand...
[quoted text clipped - 12 lines]
Can someone help?
Click to expand...
Click to expand...
 
Back
Top