View Full Version : create a form to search for 1 record


junglegrove
07-28-2001, 06:25 PM
how do you create a form that allows 1 of our customers to search for their account and display only their account without the record bar at bottom

pcs
07-29-2001, 02:52 PM
i suspect you may be asking a bigger question.

but, if you base the form on a query (not the table) that specifies the account ID in the critera section (=1234), the query will only return records for that customer, so you don't need to worry abt the record bar, (which you can turn off by selecting record selectors: No and navigation buttons: No in the form properties). this assumes that you are giving the customer a 'special' copy of the application for their own use.

if they are accessing the db on a network, then that is the 'bigger question'...

hth,
al