Search results

It's a global variable. I changed this code : .FindFirst "[chrordernumberfromparts] =" & strOrderNumberFromParts to this: .FindFirst "[chrordernumberfromparts] =""" & strOrderNumberFromParts & """" and it works. I don't understand enough about quotation marks to know why it makes a...

yes. direct copy. does compile. The only data passed is the value of the variable strOrderNumberFromParts When code execution gets to this line: .FindFirst "[chrordernumberfromparts] =" & strOrderNumberFromParts A run time error results.

I have a command button that loads a form and I want the loaded form to display a certain record, based on the variable passed to the form load procedure (called strOrderNumberFromParts). I cannot get the rsclone code below to work resulting in a run time error. Appreciate the help. Private...

ok thanks. i'll add that. I thought that was what the ".update" was for in the code. Am I wrong?

I have a control on a subform called chkOrdered that I use to update a record to indicate that an associated part has been ordered. When I click the checkbox, code executes and returns (and the record is updated accordingly). Then, when I move to the next record, I get a messagebox indicating...

Hoping to get a response...

ok, did that. no effect. Let me add that after doing more research, what I'm really trying to accomplish here is to have a subform on a tab of the main form, to update to the new record. Currently, I can make the main form requery and the record is present on the form (although I still can't...

I have a form with a command button. The form works directly with one table. The function of the command button is to create a new record in two additional tables. After clicking the command button then, three records are created: one in the table associated with the form, and the two...