Pull data from existing entries for a drop down box

[Emilia99901]

I have a database that I put information in everyday with prospective bid
invitations. There are times I get the same invitation from several different
general contractors. I would like to be able to use a drop down box or as I'm
typing the information will query the existing data and auto populate, kind
of like Excel does.

 

[Dorian]

If you are saying you have duplicated information in your table, that is not
a good design. You need to move this information into a separate table e.g. a
general contractors table. Your tables would be:

BidInvitations table:
BidInvitationId
ContractorId --> points to id in Contrators table
Bid Data

Contractors table:
ContractorId
Contractor Data

You would then have a combo box in your form to pick the contractor.

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Jeff Boyce]

Excel is a spreadsheet.

Access is a relational database.

You wouldn't use what you know about hammers to use a chain saw, would you?

If you already know Excel, then, sorry, you'll have to unlearn some things
to get the best use of Access...

(and if "relational" and "normalized" aren't familiar terms, plan on
spending some time working your way up this learning curve before trying to
get Access to do things...)

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.