Text Box Necessary

[Wayne]

MS Access 2000

I have the column InvoiceID in a query. This query is the
Record Source of a bound form. I do not have a text box
for InvoiceID on the form.

Is there a way in code to determine the InvoiceID of the
current record without using a text box that has a Control
Source of InvoiceID?

Thanks.

 

[vb]

I guess you can use
me.InvoiceId to get the current record's invoiceid

vb

 

[PC Datasheet]

Put InvoiceID in a textbox and set the visible property to False. You can also
make the textbox as small as you like. You can then reference InVoiceID with:

Me!InVoiceID