command button on continous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have continous form which lists account numbers and amount. I have
added a button and when I click on the button, I would like to query up
invoices for that account.
i put this in my query: I named a form "test" for test purpose.
IIf([Forms]![test]![txtbillto]<>"",[invoice]![acct#] Like
[Forms]![test]![txtbillto],"*")
but it is not working. Can anybody help me??

Thank you!
 
Try this

Like IIf([Forms]![test]![txtbillto]="" Or [Forms]![test]![txtbillto] Is
Null, "*",[Forms]![test]![txtbillto])
 
Thank you, it's working but not quite what I need. It is pulling invoices
for all accounts.
How do I make it pull invoices just for the account I'm on?? I have a button
right next to every account number (continous form). I need to pull invoices
only for that account(record).
Thank you!

Ofer said:
Try this

Like IIf([Forms]![test]![txtbillto]="" Or [Forms]![test]![txtbillto] Is
Null, "*",[Forms]![test]![txtbillto])

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



GEORGIA said:
Hi, I have continous form which lists account numbers and amount. I have
added a button and when I click on the button, I would like to query up
invoices for that account.
i put this in my query: I named a form "test" for test purpose.
IIf([Forms]![test]![txtbillto]<>"",[invoice]![acct#] Like
[Forms]![test]![txtbillto],"*")
but it is not working. Can anybody help me??

Thank you!
Click to expand...
Click to expand...
 
OH! I got it! Thanks again!! :-)

GEORGIA said:
Thank you, it's working but not quite what I need. It is pulling invoices
for all accounts.
How do I make it pull invoices just for the account I'm on?? I have a button
right next to every account number (continous form). I need to pull invoices
only for that account(record).
Thank you!

Ofer said:
Try this

Like IIf([Forms]![test]![txtbillto]="" Or [Forms]![test]![txtbillto] Is
Null, "*",[Forms]![test]![txtbillto])

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



GEORGIA said:
Hi, I have continous form which lists account numbers and amount. I have
added a button and when I click on the button, I would like to query up
invoices for that account.
i put this in my query: I named a form "test" for test purpose.
IIf([Forms]![test]![txtbillto]<>"",[invoice]![acct#] Like
[Forms]![test]![txtbillto],"*")
but it is not working. Can anybody help me??

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Your welcome, glad I could help


GEORGIA said:
OH! I got it! Thanks again!! :-)

GEORGIA said:
Thank you, it's working but not quite what I need. It is pulling invoices
for all accounts.
How do I make it pull invoices just for the account I'm on?? I have a button
right next to every account number (continous form). I need to pull invoices
only for that account(record).
Thank you!

Ofer said:
Try this

Like IIf([Forms]![test]![txtbillto]="" Or [Forms]![test]![txtbillto] Is
Null, "*",[Forms]![test]![txtbillto])

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



:

Hi, I have continous form which lists account numbers and amount. I have
added a button and when I click on the button, I would like to query up
invoices for that account.
i put this in my query: I named a form "test" for test purpose.
IIf([Forms]![test]![txtbillto]<>"",[invoice]![acct#] Like
[Forms]![test]![txtbillto],"*")
but it is not working. Can anybody help me??

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top