• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

How alter code if field is a text field

I have this code in an onclick event of a command button but RMA is a txt field.  How do I alter the code to make it work?

DoCmd.OpenReport "rptReturns", acViewPreview, , "[RMA]=" & Me.txtRMA, acWindowNormal

--Steve
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
DoCmd.OpenReport "rptReturns", acViewPreview, , "[RMA]='" & Me.txtRMA & "'", acWindowNormal


e x p l o d e d  v i e w

"[RMA]=' " & Me.txtRMA & " ' ",
0
 
SteveL13Author Commented:
Yep.  Thanks.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now