Can Access auto fill info? I need this function for purchae order

K

KatSpokane

I order the same items with long numbers over and over again. Can an Access
database fill in the number if I enter name info? thanks, Katy
 
J

John Vinson

I order the same items with long numbers over and over again. Can an Access
database fill in the number if I enter name info? thanks, Katy
Click to expand...

Sure. Use a Combo Box on a Form; have the human-meaningful text as the
first visible column of the combo, and the long number as the (zero
width) bound column.

Take a look at the Northwind sample database Order form. It's storing
meaningless numeric ProductID's while the user sees the name of a
product.

John W. Vinson[MVP]
 
Top