Need Urgent Help!

[Guest]

I have a form with fields like -

Order No.
.....
OrderPackList, etc.

I want to enlist records from a table into combo box using query like -

select recno, OrderPackList from OrderList where OrderNo = <user entered
ORder OrderNo on this form>

How can I use this query for the list since orderno is a variable?

Thank you,
-Me

 

[Someone]

Did the reply to your post at 18:25 not help?

 

[John Vinson]

I have a form with fields like -

Order No.
....
OrderPackList, etc.

I want to enlist records from a table into combo box using query like -

select recno, OrderPackList from OrderList where OrderNo = <user entered
ORder OrderNo on this form>

Use a criterion

=[Forms]![Name Of Your Form]![Name Of Your Order No Textbox]


John W. Vinson[MVP]

 

[Guest]

John,

Thank you very much, I was looking for this!

-Me

I have a form with fields like -

Order No.
....
OrderPackList, etc.

I want to enlist records from a table into combo box using query like -

select recno, OrderPackList from OrderList where OrderNo = <user entered
ORder OrderNo on this form>

Use a criterion

=[Forms]![Name Of Your Form]![Name Of Your Order No Textbox]


John W. Vinson[MVP]

 

[Guest]

Hi Someone,

Maybe perhaps I didn't get what the writer intended to convey, neverthless,
John's reply is on the dot and that's what I was looking for.

Thank you for your help!

-Me

 

[Guest]

John,

See if you know the answer to this one -

How can I open an access form conditionally for group of users. Someone
posted a link, its lengthy, I was wondering if you knew an easier way.

Thank you,
-Me

I have a form with fields like -

Order No.
....
OrderPackList, etc.

I want to enlist records from a table into combo box using query like -

select recno, OrderPackList from OrderList where OrderNo = <user entered
ORder OrderNo on this form>

Use a criterion

=[Forms]![Name Of Your Form]![Name Of Your Order No Textbox]


John W. Vinson[MVP]