Benny Wong
Registered User.
- Local time
- Today, 03:19
- Joined
- Jun 19, 2002
- Messages
- 65
Hi All,
I am working with Microsoft Access 2000 and I have created two forms.
The forms are frmClients and frmFindClients. The frmClients contains all the
field from the table tblClients. The form frmClients has a command button that
opens the frmFindClients form. The frmFindClients is an unbound form that contains:
user input textbox - user name field
four option buttons group to select from
Find button
Previous record and next record buttons
What I would like to happen is when the user enters the following:
user selects one of the four options from the option group then enters a
name in the input textbox then presses the find button then results will show up in frmClients form where if more that one record both forms can navigate the various number of records. The user will then close the frmFindClients form and work on the form frmClients by either edit the record or delete the record. Any ideas how to approach this is greatly appreciated. Thank You very much for your time.
I am working with Microsoft Access 2000 and I have created two forms.
The forms are frmClients and frmFindClients. The frmClients contains all the
field from the table tblClients. The form frmClients has a command button that
opens the frmFindClients form. The frmFindClients is an unbound form that contains:
user input textbox - user name field
four option buttons group to select from
Find button
Previous record and next record buttons
What I would like to happen is when the user enters the following:
user selects one of the four options from the option group then enters a
name in the input textbox then presses the find button then results will show up in frmClients form where if more that one record both forms can navigate the various number of records. The user will then close the frmFindClients form and work on the form frmClients by either edit the record or delete the record. Any ideas how to approach this is greatly appreciated. Thank You very much for your time.
