Communicating between forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rsfishel@gmail.com - 15 Mar 2007 18:39 GMT

I am REALLY having trouble with this. I have a small pop-up form with
a combo box. Within this combo box are many part numbers. There is a
"Go" button beside of the combo box. What I am trying to get to
happen is that when the user picks a part number from the combo box,
then presses the "Go" button, that another form opens displaying the
records for that part number. I really want to be able to use the
"Go" button instead of this happening autmatically when the user steps
off of the control. My pop up form combo box is called Combo11. The
"Go" button is Command3. The field on my second form is called
PARTNUM. So basically, choose a part number from the list, then open
the second form and match up the value in Combo11 with PARTNUM. I
have been working on this all day long, and would really appreciate
some help. Thank you :)

Reply to this Message

Rick Brandt - 15 Mar 2007 19:00 GMT

> I am REALLY having trouble with this. I have a small pop-up form with
> a combo box. Within this combo box are many part numbers. There is a
[quoted text clipped - 9 lines]
> have been working on this all day long, and would really appreciate
> some help. Thank you :)

What code are you using behind your button? The command button wizard would
write that code for you.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

rsfishel@gmail.com - 16 Mar 2007 12:39 GMT

> rsfis...@gmail.com wrote:
> > I am REALLY having trouble with this. I have a small pop-up form with
[quoted text clipped - 18 lines]
> Email (as appropriate) to...
> RBrandt at Hunter dot com

Rick, you were absolutely right. The command button wizard took care
of this for me EXCEPT I was hoping that the original form would close
after pulling up the new form with records on it. Any ideas? Thanks
for your help. I really appreciate it :)

Reply to this Message

Rick Brandt - 16 Mar 2007 12:42 GMT

> > rsfis...@gmail.com wrote:
> > > I am REALLY having trouble with this. I have a small pop-up form
[quoted text clipped - 24 lines]
> after pulling up the new form with records on it. Any ideas? Thanks
> for your help. I really appreciate it :)

Just add one line to what the wizard generated...

DoCmd.Close acForm, Me.Name

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Hunter57 - 16 Mar 2007 01:09 GMT

On Mar 15, 1:39 pm, rsfis...@gmail.com wrote:

You might try something like this:

Private Sub Command3_Click()

Dim strCbo As Long
strCbo = Me!Combo11

DoCmd.OpenForm "YourFormName"
Forms!YourFormName![YourPARTNUMControlName].SetFocus
DoCmd.FindRecord (strCbo)

End Sub

Reply to this Message