OpenForm Where Condition

[GendoPose]

Hi All,

I'm creating a couple of web forms and I want to open another form to show more information about the current record.

I have a continuous form with all the currently outstanding work, and when I click on a certain field I want to be able to open the Job Card form to that specific record.

In the macro's Where condition I've got it as [OutstandingID] = [Forms]![JobCard]![ID] but when I click on the field to open the form, the form just opens up to a blank record, why is this?

Thanks for any help

 

[pr2-eugin]

Make sure the Form is not set to Data Entry. Also is the Outstanding ID unique? If not then you might have a problem. I hope you are using DoCmd.OpenForm in the Macro.

 

[GendoPose]

Make sure the Form is not set to Data Entry. Also is the Outstanding ID unique? If not then you might have a problem. I hope you are using DoCmd.OpenForm in the Macro.

Neither form is Data Entry, each ID is unique but both forms look at the same set of records, so obviously the ID from Outstanding matches an ID of a record in the Job Card form. I'm using the OpenForm command in the macro builder, it's the only option it gives me.

 

[GendoPose]

Quick bump, anyone got any ideas?

I read up a little more and the where condition currently looks like this:

"[fieldname]=" & [Forms]![JobCard]![controlname]"

The fieldname is ID and the controlname is ID1, both are number fields (it's the PK and is an autonumber).

When I run the macro from the OnClick event, it filters the records but all the records are available, not in the right order and no matter which different record I click on, it always opens the form to this one specific record (ID 19).

Any ideas at all anyone?

Thanks