One Time Popup Form

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

Guest

I need some quick help. I have to do a demo for some higher ups in a few
days. I want to create a form that opens ONE time and asks specific
questions like a Project Number. Once I enter the project number, that
number gets pushed to other tables/forms that contain a field for Project
Number. Is that possible? If so, how? Please help!

Ben
 
Eric,
First I want to have a button on the first form that when i click it once it
will close the form but send the data in those text boxes to other fields in
the database. How would the code look as an example? And what do I need to
do to the "popup" form?

Thanks
 
Launch the popup form either from a command button on a form or in a macro
Named "autoexec" which will open up when you open the database.
on the popup form
run an update query that will get the info from the popup form.
the command button on the popup form will open the other forms and hi or
close the popup form.
 
Eric,
So i create a Macro called autoexec and set it to Open Form?
Then on the actual form itself run an update query.
How do i pass the data from the popup form to another form? What's the
code? I'm trying to get the steps down so I can do this...sorta an amateur.

Ben
 
add a command button use the command button wizard
use open form and finde specific data to display
select fields that match
 
Why don't you have the form open up, when they enter the values and close,
the data gets saved to the underlying table. Then reference those values in
that table from your other forms using dlookup in VBA. Would this work for
your situation?
 
Could you provide me a step by step instructions on how to create all this?
I am a newbie at access and it would help if you gave me a step by step list.

Thanks
 
What specific questions does the form have to ask? Each of these could relate
to a field on the form.
Could you create a table with the fields that you want to appear on the form
eg Project number and the other specific questions you have mentioned in your
first post.
Create a form based on that table. This form could be set to open up first
using the startup properties of your database.
When they close this first form, the values are saved to the table it is
based on.
To refer to any of the values, use the dlookup command: dlookup("[fieldname]",
"tablename")



Could you provide me a step by step instructions on how to create all this?
I am a newbie at access and it would help if you gave me a step by step list.

Thanks
Why don't you have the form open up, when they enter the values and close,
the data gets saved to the underlying table. Then reference those values in
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Back
Top