By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,213 Members | 1,426 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,213 IT Pros & Developers. It's quick & easy.

performing an unusual record search

P: n/a
i need to do a record search in a form but there are a few twists.

1. there is no unique field to any of these records
2. the form has 9 fields, 5 of which are required for creating a record.
3. the solution has to be super easy for the end-users of this database. i'm
thinking of a command button that pops up a form that let's a person select
up to 3 criteria (2 of which are one of the required fields mentioned earlier
and 1 is not -- but i don't want to require any of them for this search so i
need to allow for null values in the ones that they don't pick) and then
searching the table for all records that match those criteria. then letting
the user select which record they want to edit (i would need to know how to
let a user select a record), then closing the popups and displaying the
record in the original form, ready for editing.

i can do the button to pop the 2nd form and the controls for that form
(probably 2 text boxes and 1 combo box, if that matters) but dont' know how
to DO the search, return another popup of results, select 1 and populate the
1st form.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1
Nov 16 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
any reason a filter by form wont work?

Nov 16 '05 #2

P: n/a
i guess that depends on what 'filter by form' exactly is. i have no filters
in anything now (tables, queries or whatever) so i'm completely unfamiliar
with using them. what does it do/how does it work?

pi********@hotmail.com wrote:
any reason a filter by form wont work?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200511/1
Nov 18 '05 #3

P: n/a
"ka******@comcast.net via AccessMonster.com" <u15580@uwe> wrote in message
news:5786260a620a9@uwe...
i guess that depends on what 'filter by form' exactly is. i have no
filters
in anything now (tables, queries or whatever) so i'm completely unfamiliar
with using them. what does it do/how does it work?


Check the help file topic. Basically with a bound form open there is a
button on the toolbar that turns on FBF. It's fairly obvious how to use
once you see it.
Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.