Basically I have a report that I want to put a button in the detials section (so that it shows up on every line(record) and when clicked will open my input form with the selected record(same line as button)
something like, in the onClick() event
DoCmd.OpenForm "Customer Form", , , "[ID]=" & Me!Text19
the control source of text19 is the Customer_Name field in the details section and it displays the customer name of each record like i want, but the button wont open, i get an error:
Run-time error '3075'
Syntax error (missing operator) in query expression '[ID]=Mon Neopaney'
mon neopaney being the value of text19, derived from Customer_name
I dont know what it is that I'm missing, any help would be greatly appreciated