I’m having trouble with making a form. I want to have a combobox that drops down with a list of customer IDs and when I select the ID I want my form to go to the record for that customer ID. Currently I select a customer ID but it remains on the first record. Any idea what I can do?
Bump, +1 or even “Help, pretty please!”
betahawk :
You need to use form-based FILTERS, and if you want to filter by choosing from a drop-down list of a LIST BOX (not a COMBO BOX), you’ll need to set-up a dedicated filter table to store the KEY of list-choice which is then used to select the record-set (in your case, just a single record). See DACM’s tutorial for more info.
One question - how do you know in advance the customer ID (number)? Wouldn’t it be better to select by customer NAME?
Customer ID (usually) is not a number but a string, AKA his VAT (Registration) Number, hence is known in advance.
“Go to” a record does not mean filter, AKA does not mean make all other records disappear.