Common product shortcut button

[Chrisopia]

I am trying to create a "common product" short cut button.

Basically an update-able list of products that you select and various fields and sub fields are filled in (as if by magic).

For example, the description for ID=1 is Poster, and I want the button to fill in the field of description where ID=1 (because you have chosen poster), my trouble is there is no WHERE clause in filling in fields -

for example: DescriptionText = [tblOrder].[Description] WHERE [tblOrder].[OrderID] = 1 would fill in DescriptionText with "Poster"

But
a) the presets will be in the same table- later developed into a "copy invoice" button to copy the details from a previous similar order.

b) I can't just use a list, the fields have to be duplicated into a new record because they won't be exactly the same every time (e.g. quantities)

c) WHERE clauses don't exist with the way I know how to fill in fields...

any advice will be helpful...

 

[John Big Booty]

You could use the DLookup() function to fill in the associated details based on the ProductID.

Alternately if the product ID is being supplied by a Combo Box, you could have the associated details you wish to display, as part of the Combo's Row Source. Then use the following to populate your text box;

=CombName.Column([B][COLOR="Red"]x[/COLOR][/B])

Where x represents the column number in which that data resides. Remeber that the columns in a combo or list box are numbered from Zero up. The first column {column(0)} is often hidden and bound to the underlying Control Source.