Form Help

[chaddresnick]

I created the attached database. I would like the user to enter an account number in my "4A" line on my form called "Lookup by 4A". After they enter the account number, I would like the remaining three values to update on the form. So, I do not want to be able to add, delete, or modify form this form. I only want to enter a "4A" value and then display the results.



Can anyone help?


Database1.accdb

[ssanfu]

So what you are look for is a search form.?

I changed field names - shouldn't start a field name with a number.
Shouldn't have an autonumber visible on a form or report.

Autonumbers--What they are NOT and What They Are
http://www.utteraccess.com/wiki/index.php/Autonumbers

Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp

Use Autonumbers properly
http://access.mvps.org/access/general/gen0025.htm

[chaddresnick]

Steve:

Thank you very very much!

How do I make a "look up by 9A"? I copied the "look up by 4A" but I cannot get the Combo Box to populate. Can you help me please?
Also, on the look up forms is there a way for the Combo Box to not be a drop down? I will have some accounts that do not have a 4A number and others that will not have a 9A number. I want users to be able to enter the number and if it does not exist, an error pops up and says "Account Number Not in Use".

Thank you,
Chad

[ssanfu]

on the look up forms is there a way for the Combo Box to not be a drop down? I will have some accounts that do not have a 4A number and others that will not have a 9A number.

It is usually better to NOT have the user type in a number. Reduces "fat finger" mistakes.
Also, you do know your table structure is not normalized?


-----------------------
You know......you could have one search (look up) form, with an option to search either 4A or 9A. I'm just sayin...