themanof83
Registered User.
- Local time
- Today, 19:14
- Joined
- May 1, 2008
- Messages
- 73
Afternoon,
Still climbing the steep learning curve that is Access and VB! Please could you help.
I have a list box in one form (frm1) that displays information from a table (tbla), I also have another form (frm2) that has a combo box with the same information as tbla but can vary from record to record.
Wot I would like to do is have it so that if frm2 is opened in add mode then the combo box matches the row selected in the list box in frm1. So something along the lines of, in on Open Property of frm2:
If Me.DataEntry Then
Me.Combo.SelectedRow = [Forms]![Frm1]!
Still climbing the steep learning curve that is Access and VB! Please could you help.
I have a list box in one form (frm1) that displays information from a table (tbla), I also have another form (frm2) that has a combo box with the same information as tbla but can vary from record to record.
Wot I would like to do is have it so that if frm2 is opened in add mode then the combo box matches the row selected in the list box in frm1. So something along the lines of, in on Open Property of frm2:
If Me.DataEntry Then
Me.Combo.SelectedRow = [Forms]![Frm1]!
- .SelectedRow
End
Please help, thanx in advance.
Ash
