Populate Fields in a Form

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

Guest

I have a form which uses repetive information, rather than have someone enter
the
the info in each field everytime, I would like to have those fields
automatically filled.
My access book says to open form in design view, bring up field list, then
with the
Control wizard clicked, make a combo box and drag in the field which I need,
then the control wizard drops down and guides me through adding all the fields
which I need from a query.
I have played with this for 3 days now and cannot get anything to work.
Any one have any idea's what I am doing wrong?
Thanks for any help
Roger
 
You want the controls to have default values for new records? No need for a
combo box, unless those values are specifically related to a choice a person
is making in a combo box. Tell us more about your setup and what's happening
so that we can better advise you on which steps to take to set this up.

(Xenia, Ohio, by chance?)
 
Ken
Yes it is Xenia, Oh.
I have a Query, which I am pulling the info from.
I have put in individual combo boxes for them to make choices, but I would
like
to automate it when they make 1 selection. Say Ticket Name
TicketName =Boomers
TicketsPerBag =2000
CostPerBag =39.50
PayOutPerBag =1600.00
IdealProfit =400.00
SerialNumber
If they selected Boomers all the other info would be automatically put in the
other fields. I have a query for each of the other fields, so the combo box
only
pulls those records, and that works great, But they have to choose for each
box.
but I have put all the info in 1 query, and it still doesn't work
The serial number would have to be manually entered. Since they are different
There are 30 different selections of ticket names and each has different
amounts
that apply to them.
I have a query which has all info in it,more than what this form will put
in. and several query's which only have the info of each field
above listed in it. and 1 query which has all the info listed above in it.
Hope this helps. explain what I am trying to do.
Thanks for any help
Roger
 
Ken
Your son is only 10 miles away.
It's a good area.
It's late so I will try the code tomorrow.
Thanks for the help
Roger
 
Back
Top