Copying a field from a query to a different form and field...

[BamaBlast]

I have a Form that has a subform and in that there is a subform that runs a query. I need to take the value of in one of the fields returned in that query and transfer it to a field in my original subform. It sounded simple enough but has become a real issue to make it happen.

Suggestions and solutions welcomed....Thanks!

[BamaBlast]

I have a Form that has a subform and in that there is a subform that runs a query. I need to take the value of in one of the fields returned in that query and transfer it to a field in my original subform. It sounded simple enough but has become a real issue to make it happen.

Suggestions and solutions welcomed....Thanks!

Well I figured out how to update the field ( Forms![tbl_week view 2]![frm_qry_Hangar Day crews Sr w Ds subform]![D1] = Me.[Time Code].Value) but now I have the common problem of only updating the first record. How do I update the recordset? Newbie at work here...

[BamaBlast]

Is their anyone on this forum that would be willing to take a look at a Database I have started and help me along when I get stuck? I am currently stuck on a issue that is an absolute requirement? Once I get past this issue the database (at least in my mind) seems to be pretty straight forward even for a novice like myself. Any help or advice is greatly appreciated!

[ItsMe]

Forms are good for Users to input data. They are an interface for to the tables. When you programmatically input or update data within the database, it is a good idea to think of it as appending or updating tables. You, the developer, are not limited to using forms.

You need to identify the tables that need to be updated or appended and find a solution that does this. One approach would be an action query another would be DAO.

[BamaBlast]

Thank you very much for that advice. I had never even contemplated updating the tables. Also I keep running across DAO I guess I need to do some research on it.

Thanks again I'll keep working on it. I'm starting think I may need to start over and try a different structure. Thx.