Feild in data souce not available

  • Thread starter Thread starter Jim C.
  • Start date Start date
J

Jim C.

I would like to set the value of a control on my form based on a field
in the form's data source that is not bound to any control.

When I try to reference this field I get a 'Field Not Found ' error.

What's the secret here guys? I have tried all the syntax variations I
can think of but to no avail. I am even desparate enough to place an
invisible field on my form, is this my only alternative?

Regards,

Jim C.
Using MS Office 97, MS Windows 98
 
Thanks Cheryl:

Maybe a record set clone would be another method I should consider,
but it is probably a more complicated method.


Do you know if the record pointer in a record set clone is at the same
point as the forms record pointer?




This is done frequently when you want to reference a form's recordset data
without the user viewing or editing that field. Nothing wrong with that
approach.
Click to expand...

Regards,

Jim C.
Using MS Office 97, MS Windows 98
 
Do you know if the record pointer in a record set clone is at the same
point as the forms record pointer?
Click to expand...

According to VBA Help, when using Recordset.Clone "each Recordset can have
its own current record". So, I would say that the answer is "not
necessarily".

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Jim C. said:
Thanks Cheryl:

Maybe a record set clone would be another method I should consider,
but it is probably a more complicated method.


Do you know if the record pointer in a record set clone is at the same
point as the forms record pointer?






Regards,

Jim C.
Using MS Office 97, MS Windows 98


----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
Click to expand...
=---
 
Jim said:
I would like to set the value of a control on my form based on a field
in the form's data source that is not bound to any control.

When I try to reference this field I get a 'Field Not Found ' error.

What's the secret here guys? I have tried all the syntax variations I
can think of but to no avail. I am even desparate enough to place an
invisible field on my form, is this my only alternative?
Click to expand...

The VBA code behind the form can refer to a field in a
form's record source by using Me.fieldname.

In a text box's expression you could use =Form.fieldname,
but the question is Why? The only thing this accomplishes
is to make the text box uneditable and that can be done in a
much less obscure way by using the Locked property .
 
Back
Top