Bizarre..can't figure this one out

I am using Access 97. I have a database that is used to schedule inbound
appointments. On the scheduling form, one piece of information required is
the vendor name. I am using a look up box to the vendor table.

When the carrier arrives with the load, we use another form to input
relevant information for the load. This form is based on a query of the
appointment schedule. We enter the Probill number and a combo box matches it
to the record with the matching probill.

Here's the problem, it works fine for any vendor that is already on the
vendor table. If I use the Add Vendor form to add a new vendor, the vendor
will appear in the lookup box on the scheduling form, however the record will
not appear in the query.

Any help would be greatly appreciated.

Thanks,

Linda

I swear right after I posted this question the answer occured to me. As
usual, it was something stupidly easy. There was a field in the vendor table
that I did not fill in. WIthout the info in that field, the query didn't
recognize it. DUH.

"Boz" wrote:

I am using Access 97. I have a database that is used to schedule inbound
appointments. On the scheduling form, one piece of information required is
the vendor name. I am using a look up box to the vendor table.

When the carrier arrives with the load, we use another form to input
relevant information for the load. This form is based on a query of the
appointment schedule. We enter the Probill number and a combo box matches it
to the record with the matching probill.

Here's the problem, it works fine for any vendor that is already on the
vendor table. If I use the Add Vendor form to add a new vendor, the vendor
will appear in the lookup box on the scheduling form, however the record will
not appear in the query.

Any help would be greatly appreciated.

Thanks,

Linda

Some complicated queries tend to have simple solutions. It happens to me :-)


"Boz" wrote:

I swear right after I posted this question the answer occured to me. As
usual, it was something stupidly easy. There was a field in the vendor table
that I did not fill in. WIthout the info in that field, the query didn't
recognize it. DUH.

"Boz" wrote:

I am using Access 97. I have a database that is used to schedule inbound
appointments. On the scheduling form, one piece of information required is
the vendor name. I am using a look up box to the vendor table.

When the carrier arrives with the load, we use another form to input
relevant information for the load. This form is based on a query of the
appointment schedule. We enter the Probill number and a combo box matches it
to the record with the matching probill.

Here's the problem, it works fine for any vendor that is already on the
vendor table. If I use the Add Vendor form to add a new vendor, the vendor
will appear in the lookup box on the scheduling form, however the record will
not appear in the query.

Any help would be greatly appreciated.

Thanks,

Linda

I have found that there is no better way to figure out a problem then to send
it out to a forum or newsgroup. Within seconds (1) the answer comes to me or
(2) someone will respond with something obvious that I missed.

Often just the act of typing up an explanation of the problem helps me solve
it.

Either way, these forums are great!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Boz" wrote:

I swear right after I posted this question the answer occured to me. As
usual, it was something stupidly easy. There was a field in the vendor table
that I did not fill in. WIthout the info in that field, the query didn't
recognize it. DUH.

"Boz" wrote:

I am using Access 97. I have a database that is used to schedule inbound
appointments. On the scheduling form, one piece of information required is
the vendor name. I am using a look up box to the vendor table.

When the carrier arrives with the load, we use another form to input
relevant information for the load. This form is based on a query of the
appointment schedule. We enter the Probill number and a combo box matches it
to the record with the matching probill.

Here's the problem, it works fine for any vendor that is already on the
vendor table. If I use the Add Vendor form to add a new vendor, the vendor
will appear in the lookup box on the scheduling form, however the record will
not appear in the query.

Any help would be greatly appreciated.

Thanks,

Linda