entering data in a lookup field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have 2 tables called master & venues that have a one 2 many relationship
(venues being the one side and join field called vref)
i want to bring into the master form the address details of venues i use
regularly but i also want to be able to type directly into the address field
info details of 'one off' venues that i will never use again. if i use a
control bound to the venues table address field, access won't let me type any
data into the field.
can anybody help with this one please.
 
Is the bound column of the combo visible?

If it is not zero-width, you can use the NotInList event of the combo to add
the new value to the Venues table. Example in:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html

If it is zero-width, or you have other required fields you need to enter for
a venue, you could use the DblClick event of the combo to open the form
where you enter venues. Then in the AfterUpdate event of this *form* (and
also the AfterDelConfirm event), Requery the combo that is still open in the
background so that the changes are there when you get back there.
 
thanks for the help allen.

what you suggest is ok but i don't want to store the 'one off' address in
the venue table as this will result over a period of time in a lot of
addresses i will never use again . in addition, the combo drop down box will
become cluttered with references to these addresses.
i want to be able to store the 'one off' addresses in the master table. if i
could store any address whether derived from the combo or typed into the
master table then this would do the job. not exactly classic rdbms method but
would solve my problem.

thanks for any further help you could give.
 
Faffy, I don't think I have a suggestion, as I don't design things that way.

Maybe someone else does.
 
Back
Top