I am an amateur with no Visual Basic training, but I'm trying to learn. Help appreciated.
I have a standard form/subform with supporting tables in one-many relationship. The subform shows only name data for individuals from its supporting table (called tblMInfo); but I have another form based on that same table that shows additional information about each individual
I would like to insert a control on the subform record that when activated saves the current record and opens the other form (with the additional information), butshowing only the current record.
Not knowing Visual Basic I was able to create a Macro that opens the form with additional information, but I don't know how to filter it so that I get only the current record. It would also be nice to have the current record saved before the form with the additional information is opened.
I have a standard form/subform with supporting tables in one-many relationship. The subform shows only name data for individuals from its supporting table (called tblMInfo); but I have another form based on that same table that shows additional information about each individual
I would like to insert a control on the subform record that when activated saves the current record and opens the other form (with the additional information), butshowing only the current record.
Not knowing Visual Basic I was able to create a Macro that opens the form with additional information, but I don't know how to filter it so that I get only the current record. It would also be nice to have the current record saved before the form with the additional information is opened.