I am creating a Security Incident Report database (similar to a police report) I have a combo Box in Table1 and under the field [Report Subject:] I have a combo box. My goal is to get the combo box to display the list of subjects in the table [ReportSubjects] as well as add any new data to the drop down box when the user is filling out the form Which was created from Table1. I have the combo box linked to the second table, and it displays the list of Subject Reports my problem is....Is it possible to have user entered data in the [Report Subject:] field using Table1 fields to update in the ReportSubjects list of subjects? I cannot possibly enter all possible subjects that a report may be written about, so it would be easier if the list would self update if a user entered in a subject not on the list already. If this was a bit confusing I have been working on this database for 24 hours straight. Please Help. If any clarification is neccessary I will try, just ask me a question.
Also in case it wasnt clear enough (I am usually confusing to others,especially when tired)
The user will Enter data into a form which I created using a wizard off of Table1. The combo box for Report Subject is based on the table ReportSubjects. Can I have data the user types in the combo box in the form that is not already on the list added to the ReportSubjects table, even though the form is based off of Table1?
(The Sleep Deprived) Neowynds
Also in case it wasnt clear enough (I am usually confusing to others,especially when tired)
The user will Enter data into a form which I created using a wizard off of Table1. The combo box for Report Subject is based on the table ReportSubjects. Can I have data the user types in the combo box in the form that is not already on the list added to the ReportSubjects table, even though the form is based off of Table1?
(The Sleep Deprived) Neowynds