Problem in obtaining parameter from input form

**adnancanada** · 01-25-2016, 08:54 PM

I have form f_extract. it has one input box name "txtvdrid". Please note that in Query Vendor ID is like that 2342A, 34543B so I m using like function.

I have query Q_expense

I am using that parameter in my query.

like "*" &[forms]![f_extract]![txtvdrid]& "*"

query runs fine when I use like function without input parameter but whenever I use
like "*" &[forms]![f_extract]![txtvdrid]& "*"

give me message please enter parameter value. It s really pain in the butt.

Please help me out.

**cyanidem** · 01-26-2016, 02:56 AM

Try:

Code:

Forms![f_extract]![txtvdrid].Value

**adnancanada** · 01-26-2016, 08:25 AM

Originally Posted by cyanidem

Try:

Code:

Forms![f_extract]![txtvdrid].Value

Tried its not working.

**cyanidem** · 01-26-2016, 08:34 AM

Should work (without value though).

Code:

Forms![f_extract]![txtvdrid]

Double check if there's no mispelling in form name or text box name. And show us please what exact message do you receive (with parameter name).

Problem in obtaining parameter from input form

Thread Tools

Problem in obtaining parameter from input form

Similar Threads

Obtaining multiple report parameters via a Menu form lookup control

Input Parameter Not Working

Obtaining a value in a form from a table

Use input from form not pop-up parameter

Form Input Problem

Posting Permissions