Help! -Useful Data Entry concept - poor development concept

[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!!

 

[Phil Hunt]

This is under the topic Form/SubForm. You can actually use the wizard to
create form/subform to handle what you described.

 

[Tim Ferguson]

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.

Look up help for the NotInList event.


Tim F