M
Matt C via AccessMonster.com
A company can have several logs
A log has several records
problem 1.
I have a form with data about the logs. It gets its data for the company
field from the company table via a combo bos, it holds the value of the
companyID (an autonumber) but displays the company name in the combo box.
How can I get the form to look up the log for a company as the user types the
name of the company into the combo box? Using the wizzard it only allows the
user to search for a company via the company ID, which is a number.
Problem 1
On the same form I want to prevent the user editing or adding to the log
records, however I would like the user to be able to make changes and
additions to records in the subform. Setting the allow additions property to
false in the main form, also prevents additions in the subform, even though
they have separate property boxes, is there a way around this?
A log has several records
problem 1.
I have a form with data about the logs. It gets its data for the company
field from the company table via a combo bos, it holds the value of the
companyID (an autonumber) but displays the company name in the combo box.
How can I get the form to look up the log for a company as the user types the
name of the company into the combo box? Using the wizzard it only allows the
user to search for a company via the company ID, which is a number.
Problem 1
On the same form I want to prevent the user editing or adding to the log
records, however I would like the user to be able to make changes and
additions to records in the subform. Setting the allow additions property to
false in the main form, also prevents additions in the subform, even though
they have separate property boxes, is there a way around this?