object required

  • Thread starter Thread starter Sammy
  • Start date Start date
S

Sammy

The following code produces the error "Object Required".
What am I missing?

Dim frm As Form
DoCmd.OpenForm "Wtn Receipts Edit"
Set frm = Forms![WTN Receipts Edit]
frm.Controls!ReceiptID = Me!ReceiptID

Thanks.
Sammy
 
Hi Sammy,

I don't see anything that would cause an error - which line is highlighted
when the error occurs?

FWIW, this statement has an unusual (though not incorrect) syntax:

frm.Controls!ReceiptID = Me!ReceiptID

I would write this as either of the following:

frm!ReceiptId or
frm.ReceiptId

Regardless, I doubt that's the problem . . .
 
The suspect line produces the error:
frm.Controls!ReceiptID = Me!ReceiptID

I have found a work-around for this problem. Thanks.
-----Original Message-----
Hi Sammy,

I don't see anything that would cause an error - which line is highlighted
when the error occurs?

FWIW, this statement has an unusual (though not incorrect) syntax:

frm.Controls!ReceiptID = Me!ReceiptID

I would write this as either of the following:

frm!ReceiptId or
frm.ReceiptId

Regardless, I doubt that's the problem . . .

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.
The following code produces the error "Object Required".
What am I missing?

Dim frm As Form
DoCmd.OpenForm "Wtn Receipts Edit"
Set frm = Forms![WTN Receipts Edit]
frm.Controls!ReceiptID = Me!ReceiptID

Thanks.
Sammy
Click to expand...

.
Click to expand...
 
Back
Top