Ask Your Question
2

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

Comments

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
0

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

Comments

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

Stats

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

Seen: 1,172 times

Last updated: Dec 16 '13