Subform record fills Fields

[lloydmav]

Right I'm in need of help AGAIN!

This time I have a form with a subform on the left which is linked to a Requests table. This is read only sub form. What I want to do is select a record from this subform and this selected record is then filled into the fields on the right of the subform on the main form. Do these fields need to be bound to the fields in the sub form or to the fields in the table or what?

Also there will be two checkboxes. Reject and Accept. If the Accept checkbox is selected then the Status field in the table/subform is changed to "Request Accepted" and if it is Rejected the field becomes "Request Rejected".

Its alot to ask but could someone help me out with this?

Thanks

 

[llkhoutx]

The subform and the form are bound to different tables/queries. fields in the subform have to be manually stuffed into the form on some event.

 

[lloydmav]

How do you manually grab that data from a selected record in a subform?

 

[llkhoutx]

One solution is simple replacement:

forms!YourMainform!txtField1=forms!YourMainform!YourSybform!txtfield42