Openig form to specific record.

[lynthel]

HelpMePlease.zipWhen trying to open a form to a specific record, a window pops up asking for the value of "txt_program_no"


Isn't this supposed to be filled in with Me.lst_program_query upon opening form "frm_travelers_form"?
I have even tried adding .Value to the end of Me.lst_program_query

here is my VBA code...

Private Sub btn_open_form_Click()
    DoCmd.OpenForm "frm_travelers_form", , , "txt_program_no= " & Me.lst_program_query
    Me.Filter = True
End Sub

[June7]

Is txt_program_no a field in frm_travelers_frm RecordSource?

Is it a number or text type field?

Why the Me.Filter = True line?

[lynthel]

txt_program_no is a field in the form frm_travelers_form. I want frm_travelers_form to open with record from Me.lst_program_query.

I thought I had to have the filter set to true...?

[June7]

The filter line you have will be applied to the form with the button, not the form you are opening. The Me qualifier references the form that has the code.

The WHERE argument in the OpenForm method should cause the form to be filtered.

I don't know why the code is not finding txt_program_no.

If you want to provide db for analysis, follow instructions at bottom of my post.

[lynthel]

Is txt_program_no a field in frm_travelers_frm RecordSource?

Is it a number or text type field?

Why the Me.Filter = True line?

txt_program_no is a text box bound to the table [tbl_travelers_programs]![tiw_program_no]
It is a number field.

The filter line you have will be applied to the form with the button, not the form you are opening. The Me qualifier references the form that has the code.

The WHERE argument in the OpenForm method should cause the form to be filtered.

I don't know why the code is not finding txt_program_no.

If you want to provide db for analysis, follow instructions at bottom of my post.

Attached DB...thanks

[June7]

There is nothing attached to your post.

The WHERE argument must reference a field name in the form being opened.

DoCmd.OpenForm "frm_travelers_form", , , "tiw_program_no = " & Me.lst_program_query

[lynthel]

There is nothing attached to your post.

The WHERE argument must reference a field name in the form being opened.

DoCmd.OpenForm "frm_travelers_form", , , "tiw_program_no = " & Me.lst_program_query

I attached it to my main post...I can see it...called "HelpMePlease.zip"

[June7]

Okay, I was only looking at latest post, never noticed it on first post if it was originally there.

Did you try the code revision I suggested?

[lynthel]

Okay, I was only looking at latest post, never noticed it on first post if it was originally there.

Did you try the code revision I suggested?

I just did...that did the trick...now to work out all the other bugs...thank you June7