Pop up form to fill in all new records in form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For each record in the form, the user will need to enter the month and year
of this record should be included with. In the interest of saving time and
not entering the same data multiple times, I would like to have some kind of
a pop up form that opens when the main form first opens....they would enter
the month and year on that form. Then, as they're adding a new record on the
main form, the month and year would all ready be populated.

I've experimented with it but it's not working so far. I got the form to
pop up but it didn't populate the new records. I'm not very experienced with
VB code so I've tried to pull from past questions but nothing I've seen has
really helped me out.

Thanks in advance!
 
You do not want to use a "PopUp" form due to its very nature that it retains
focus until closed.
Add unbound texxt boxes to your form - can be in the header of the form.
Set the default of your fields of the form to ---
=[Forms]![YourFormName]![YourUnboundTextBoxName]
 
Beautiful, I think this is exactly what I want, thank you!!

A couple questions about it, though.

Despite setting the unbound text boxes as tab stops, the first record of the
form detail has the focus when you open the form. Is there any way to force
the user to fill in the month and year in the header before proceding with
the detail?

Also, after updating the month and year in the heading, tab doesn't take you
to the form detail, it just cycles back and forth with the fields in the
header. And, possibly part of the same problem...I manually click on the
first field of the first record to start entering data. It then creates a
new record below (Form set to resemble a spreadsheet with one line per
record). The NEW record has the month and year defaulting in, but the
current record does not.

Thanks for any more help you can give me!

KARL DEWEY said:
You do not want to use a "PopUp" form due to its very nature that it retains
focus until closed.
Add unbound texxt boxes to your form - can be in the header of the form.
Set the default of your fields of the form to ---
=[Forms]![YourFormName]![YourUnboundTextBoxName]
--
KARL DEWEY
Build a little - Test a little


kbeana said:
For each record in the form, the user will need to enter the month and year
of this record should be included with. In the interest of saving time and
not entering the same data multiple times, I would like to have some kind of
a pop up form that opens when the main form first opens....they would enter
the month and year on that form. Then, as they're adding a new record on the
main form, the month and year would all ready be populated.

I've experimented with it but it's not working so far. I got the form to
pop up but it didn't populate the new records. I'm not very experienced with
VB code so I've tried to pull from past questions but nothing I've seen has
really helped me out.

Thanks in advance!
Click to expand...
Click to expand...
 
Beautiful, thank you!

I did some experimenting with SetFocus and got it to start with those fields
in the header and afterwards move to the first record in the detail section.

The problem I ran into, though. It doesn't populate the month and year from
the header on the first record. Every record after that it does, though.
Any suggestions?

KARL DEWEY said:
You do not want to use a "PopUp" form due to its very nature that it retains
focus until closed.
Add unbound texxt boxes to your form - can be in the header of the form.
Set the default of your fields of the form to ---
=[Forms]![YourFormName]![YourUnboundTextBoxName]
--
KARL DEWEY
Build a little - Test a little


kbeana said:
For each record in the form, the user will need to enter the month and year
of this record should be included with. In the interest of saving time and
not entering the same data multiple times, I would like to have some kind of
a pop up form that opens when the main form first opens....they would enter
the month and year on that form. Then, as they're adding a new record on the
main form, the month and year would all ready be populated.

I've experimented with it but it's not working so far. I got the form to
pop up but it didn't populate the new records. I'm not very experienced with
VB code so I've tried to pull from past questions but nothing I've seen has
really helped me out.

Thanks in advance!
Click to expand...
Click to expand...
 
Back
Top