???
"in case if need to update selected record." If you have to update that record, then this is separate from the Double Click event. Hpw do you (or user) know if an update is required?
"when I try to populate fRequest form all combo boxes on this form don't display data" Why would you expect the comboboxes to be populated - do you have explicit code to select values for each combo?
"when double click event executed all controls in the fRequest form should be get data from fInventory form."The rowsource of the listbox
Code:
SELECT qReqDevLoc.RequestID
, qReqDevLoc.Date
, qReqDevLoc.[Employee Name]
, qReqDevLoc.TicketNo AS [Ticket#]
, qReqDevLoc.Amount
, qReqDevLoc.Department
, qReqDevLoc.Device
, qReqDevLoc.Model
, qReqDevLoc.Location
FROM qReqDevLoc;
does not have values for all controls on fRequest. You need more code or manual intervention to populate those controls on fRequest.
You continue to describe the double click and fInventory and fRequest in database terms.
Can you step back and tell us what "business process(es)" this series of forms and events is suppose to support in simple English?
When you were given requirements, nobody said I want to double click a listbox and xxxxxx will happen. Someone said something long the lines of "we get requests from 'clients?' who want some equipment installed/moved to some location."