Combo on popup form to find a record on another.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have an "frmAddresses" with buttons for New/Edit/Delete records all
supplied by the wizard.

When I attempt to place a combo box on this form I get conflicts.

So my idea to find a record is to use a separate popup form to contain the
combo box, and use this to refer to the "frmAddresses".

But how do I make this happen? I need something like the Master/Child
relationship of Main/Subforms.

Can some one give some starting ideas? Regards Frank
 
Dear Frank:

Well, I'm not an expert, but since no expert has jumped in so far...

What you want to do sounds quite routine. It should be possible to put a
combobox on a form, and use it to locate a record. There is actually a
wizard to automate this. You say "I get conflicts." when you try to create
the combobox; what exactly happens? Do you get error messages? What do the
error messages say? Or does it work incorrectly? Or not work at all?

I'd suggest that the use of a popup form may not be necessary, if you can
get the combobox to work. Let's see if that is possible first.

HTH
Fred Boer
 
I have Access2000
I am using two wizards in total. The first is the combo box wizard to find
a particular record, and also a "Add/Delete/Duplicate/New-record" wizard to
manipulate the adding of records etc.
When the combo box wizard is present the "duplicate record" function will
not work.

But I thing I can solve the problem buy disableing the combo box with
"Me.Combo0 = disable" with the same button as the "duplicate record".
Regards Frank
 
Dear Frank:

Hmm... Let's see if we can work out some terminology to start with, ok? When
you design a form, the "Wizards" can help you to create command buttons,
comboboxes, and so on. So, am I correct in assuming that you have
successfully created a form, and that on this form you have a combobox and
some command buttons? I don't understand what you mean when you say "When
the combo box wizard is present the "duplicate record" function will not
work"; the Wizards are used when you design/create the form, not when the
form is finished. Are you saying that once you've added a combobox to the
form the command button for "Duplicate Record" won't work?

Fred
 
Back
Top