New User, Obtain data from a table

[bgoad]

I have a form that has an active record, I have several fields in the record that are not items of the form. Can I gain access to them? If so what is the best way to handle this? BTW my form is bound.

Thanks in advance,
Brian

 

[FoFa]

You could add fields to your form and bind those fields to the Db fields. This would give you access to them. If you just don't want to show them, you can set the fields invisible (visible property = false) and you still have acess to them as a form field, you just can't see them. Or rephrase you question...

 

[The_Doc_Man]

Well, there is the possibility of using the recordsetclone of the recordset that drives your form. Look that up in the help files. If you write code in VBA under the form, you can do that and use the fields from the clone of your recordset. You have to set the bookmark for the clone to match the bookmark of the current record.