Help! -Useful Data Entry concept - poor development concept

  • Thread starter Thread starter Adam Hobart
  • Start date Start date
A

Adam Hobart

Hello,
In my database, I have a form I'll call "Main" and a table
I'll call "Child". Child contains a table of contacts -
first name, last name, ID, etc. ID is a AutoNumber
Primary Key. On the Main form, there is a combo box
lookup, where I can choose the contact I wish, or type the
first few letters of their name and hit tab. This is
WONDERFUL functionality.
But...
What would absolutely make my day is a procedure by which
I could type in a contact name, and if it did not match
any contact name in the "Child" table, it would
automatically open up the form for the "Child" table.
Of course, the problem is that the Contact's name isn't
<em>really</em> what's in the "Main" form, it's the
Contact's ID number, so this makes coding this rather
difficult. In addition, the LimitToList property gets
cranky if I say I don't want to limit, because, again, I'm
inputting a different data type.
I'm positive that this has had to be thought of before,
and I'm not asking for verbatim code, but any pointers in
the right direction would be greatly appreciated. Thanks!!
 
This is under the topic Form/SubForm. You can actually use the wizard to
create form/subform to handle what you described.
 
What would absolutely make my day is a procedure by which
I could type in a contact name, and if it did not match
any contact name in the "Child" table, it would
automatically open up the form for the "Child" table.
Click to expand...

Look up help for the NotInList event.


Tim F
 
Back
Top