Auto- Populate certain Fields

  • Thread starter Thread starter Jan J Molvak Jr
  • Start date Start date
J

Jan J Molvak Jr

I have been Volun-told to create a database for tracking incoming inventories
from numerous accounts (only because I could spell Access correctly, I
think). I have set up the tables and forms that I need so far. The main form
that we use has a field called Acct_ID (six digit account number), I wolud
like to be able to have various field on the Main form populated based on the
Acct_ID entry. There is already a table that contains all the info for every
account (ie. manager_name, Comm_phone, etc.). I have seen this done before,
but I can't figure it out.
If this description is to vague, I may be able to explain it in more
detail. Thanks in advance for the help.
 
Put a combo box on your form. Have the combo wizard set the file it looks at
to your ID number field in your table. Then go into the properties of the
combo (right click) under events find the afterupdate event, start the code
builder (out to the right) and type:
Me.filter = "[acct_id] = """ & Me.combo & """"
Me.filteron = true
The combo wil be like combo10 or combo6. It will show when you go to code
builder. Now you will scroll to the id you want and the rest will
autopopulate.
 
Thank you for the quick response, but I found another way to do it with out
coding. I used an example from a website that utilizes the expression
builder. I have printed a copy of your reply so I can use it for futre
refernce.
 
Golfnray, I was wondering if you could give me some advice on this problem
I'm having. I have a plan number on my form that I would like to enter the
number and have the plan name and other info related to the plan number
automatically populate after the plan number is entered. I tried what you
suggested here but it didn't work this is what I have on the after update:
Me.filter = "[plannumber] = """ & Me.combo & """"
Me.filteron = true

Thanks in advance

Golfinray said:
Put a combo box on your form. Have the combo wizard set the file it looks at
to your ID number field in your table. Then go into the properties of the
combo (right click) under events find the afterupdate event, start the code
builder (out to the right) and type:
Me.filter = "[acct_id] = """ & Me.combo & """"
Me.filteron = true
The combo wil be like combo10 or combo6. It will show when you go to code
builder. Now you will scroll to the id you want and the rest will
autopopulate.

Jan J Molvak Jr said:
I have been Volun-told to create a database for tracking incoming inventories
from numerous accounts (only because I could spell Access correctly, I
think). I have set up the tables and forms that I need so far. The main form
that we use has a field called Acct_ID (six digit account number), I wolud
like to be able to have various field on the Main form populated based on the
Acct_ID entry. There is already a table that contains all the info for every
account (ie. manager_name, Comm_phone, etc.). I have seen this done before,
but I can't figure it out.
If this description is to vague, I may be able to explain it in more
detail. Thanks in advance for the help.
Click to expand...
Click to expand...
 
Back
Top