creating form

[Brandi]

I am trying to create a form that contains information
about companies and claims. I am trying to use an
autolookup query so that each time I input a company's ID
number, all of the information will then pop up in the
various form fields for that company. On top of that I
want to use a second autolookup query within the form.
The second autolookup query is for codes and then an
explanation for those codes (ie. if I put in a two letter
code in a field, I want the autolookup query to pull up an
exact explanation of that code). I have been able to get
these two things to work in forms by themselves, but once
I put the two together, I have had various problems, such
as, it will not allow me to insert new records, nor update
old records. Is it possible to get this to work and if so
how?

 

[Paul]

Ideally you would do the two-letter-code lookup programmatically with
unbound controls, but as a quick solution you could just use a main form and
a subform but do not link them.

You should be able to just drag your code lookup form (from the database
window) onto your company look up form and check the resulting subform's
properties to ensure Access has not automatically created a link between
them.