Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access data in subform according to its place

Status
Not open for further replies.

virginie

Programmer
Jul 24, 2002
53
IL
i have a subform bound.

i have a checkbttn in the principal form and i want, if i check it to true, to write date in a field of the subform, for all the records in the subform, for this field.
1. how can it be done?
i success to write the date for 1 records, the activate one i think, but i cant write simultaneously on the whole colu,m for all the records of this field.
how can i do that?

2. how can i access a specific record line from code in this subform, and navigate in the record set?

i can send the code if it can help

thanks!
 
Have you used recordsets?
I'd recommend opening a recordset in either DAO or ADO, make the changes you want and then refresh (.requery) the subform so it shows your changes.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top