Question Combine functions of Combo and Text Box

[Poindexter]

I am fairly new to access, I have built a form for data entry and tables, which the form is bound to a master table and references various table as options the user can select. The form is being used to record evaluations of various documents for consistencies with other policies. As we have moved forward with the project, it has become apparent that some documents need to have multiple records in order to track its inconsistencies. The other issue is that currently we do not know what or how many documents will be reviewed (so far it seems like a mushroom cloud).

I was wondering is there away to combine the function of a combo box with the function of a text box so that I can select a previous reviewed document or if it is a new document type in the new document in the same location? It would than store the new document in a table of documents and reference it in the master table.

If this is not possible, how do I run a query to return each document only once?

 

[ezfriend]

This may not be the correct way to do it, but it appears to work for my application.

Form Cycle Propert = Current Record

See attachment.

EZ