DoCmd. Question

[Trojnfn]

I currently have a button with this command :
DoCmd.OpenReport "Report Name", , "ID = " & Me.ID



I have this in my search form and it will bring up all records and I click on the button and it will just display that one record that corresponds to the id, on a report. Works fine.

What I want to do is to display that record on another form instead of a report so that I can make changes.

I tried to use DoCmd.OpenForm and it does bring up a form but it is blank. Seems like the ID is blank or cannot be found.

I am using the exact same code but just changed the OpenReport to OpenForm and it does not work.

How can I do this ?

[boblarson]

You appear to be missing a comma.

It really should be

DoCmd.OpenReport "ReportName", acViewPreview, , "ID = " & Me.ID

So, if you are just printing immediately you would either have acViewPreview set to acViewNormal or just leave it out like you have it. But you need to have THREE (3) commas after the report name for this.

And the Form would be

DoCmd.OpenForm "FormNameHere", acNormal, , "ID=" & Me.Id

with the same THREE commas after the form name.

[Trojnfn]

You appear to be missing a comma.

It really should be

DoCmd.OpenReport "ReportName", acViewPreview, , "ID = " & Me.ID

So, if you are just printing immediately you would either have acViewPreview set to acViewNormal or just leave it out like you have it. But you need to have THREE (3) commas after the report name for this.

And the Form would be

DoCmd.OpenForm "FormNameHere", acNormal, , "ID=" & Me.Id

with the same THREE commas after the form name.

I made the changes but that did not seem to make any difference, so I assume it must be the form ?

The form does display and it is completely blank. The ID that I am passing and displaying on the form (to make sure it is passing the correct value) is blank. In fact, the ID field displays (New) in it, like a table in datasheet view ready to add a new record.

Any ideas on why the id is not being passed to get the corresponding record ?

[boblarson]

Make sure that the form's DATA ENTRY property isn't set to YES.

[Trojnfn]

Make sure that the form's DATA ENTRY property isn't set to YES.

That did it ! It was set to Yes and I changed it to No and tested and it works great, proper ID is being passed.

Thanks for your help.