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

combo box conversion problem

P: n/a
Hi folks.

I am using Access 97. I have a form, frmHistory, which has 2 combo
boxes (cboSelectTitle and cboSelectName) and 2 text boxes (Title and
MemName). When the form is opened, it displays all the (dummy) history
of books borrowed by members. Both the combo boxes uses macros, with
the following actions.

cboSelectTitle:
OpenForm: Form Name: frmHistory
Where: [Title]=[Forms]![frmHistory]![cboSelectTitle]

cboSelectName:
OpenForm: Form Name: frmHistory
Where: [MemName]=[Forms]![frmHistory]![cboSelectName]

What it does is that the user can choose a name or title from the
respective combo box and the form will be filtered to diplay records
pertaining to the user's choice. For example, if the user chooses the
name "aravind" from the combo box cboSelectName, the form (frmHistory)
will display all records where MemName = 'aravind'. The problem is
that, while this works perfectly in Access 97, it doesn't seem to work
when I convert it to Access 2000, i.e. when I choose "aravind", it
diplays aravind's records, but when I then choose "frankie", it still
displays aravind's records. So what went wrong? Also, the combo boxes
uses a macro action (SendKeys: Keystrokes: %{Down}), which makes the
combo box displays its contents when it gets focus. The thing is,
should I assign it to the OnGotFocus event or the OnEnter event? What
is the difference between the 2? Thank you.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.