CODEWITHSUNDEEP
ms-accessvbams-access-2007
mhegazy
mhegazy

Reputation: 57

Link fields of same values in different forms in MS Access

I have an MS access project with four forms one main form (BS&W Data) and three subsequent forms (WellTest form, LoopSamplers Form and WellheadSamples form). The subsequent form will be opened by a command button on the main form based on the value of a specific field (Follow-up Method). I need to link three fields common between the main form (BS&W Data) and other forms, so by data input in these fields in the main form and then opening the subsequent form finding the same fields populated without re-input. The three field are (Date, Well Name and Follow-up Method)

Thanks

Upvotes: 0

Views: 1931

Answers (1)

ApplePie
ApplePie

Reputation: 8942

If you open your form with modal property, you will need to pass parameters as arguments to the form using DoCmd.OpenForm

http://msdn.microsoft.com/en-us/library/office/ff820845.aspx

Otherwise, you can use the following syntax to access directly the control's value and modify it. Of course, it has to be open first to make it work.

Forms("subform_name")("control_name").value = ...

Upvotes: 0

Related Questions