Ask Your Question

Go To Record in Base Forms [closed]

asked 2013-03-01 18:15:51 +0100

betahawk gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 17:00:10.803357


Bump, +1 or even "Help, pretty please!"

polpot gravatar imagepolpot ( 2013-12-16 20:45:27 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-12-16 23:31:15 +0100

frofa gravatar image

updated 2013-12-16 23:35:10 +0100

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?

edit flag offensive delete link more


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.

xoristzatziki gravatar imagexoristzatziki ( 2017-10-17 06:13:43 +0100 )edit

Question Tools


Asked: 2013-03-01 18:15:51 +0100

Seen: 1,277 times

Last updated: Dec 16 '13