autocomplete query

[steely via AccessMonster.com]

I recently created an autocomplete query to autofill several fields on form
"b" from entered fields on form "A" (forms A & B are identical). The
autofilled fields of form B are set to the control source of the combo box
which has the primary key for the two related tables. The other non-
autofilled fields in form B have a separate table as their control source.
When entering new records I do get all of the autofilled fields to fill but
these values do not show up in the table which is th control source for the
rest of the fields. My question is how do I get the autofilled fields to
also show in the control source table for form B.

Any help or advice would be greatly appreciated.

Steely.

 

[Jeff Boyce]

You've described "how" you've done something, but not "why" (and I'm having
trouble envisioning your underlying data structure). Could you explain what
business need you are trying to solve by using two forms with multiple
matching fields?

If you are actually trying to copy values from one table to another, your
data structure may benefit from further normalization. It is quite rare, in
a well-designed relational database, to need to copy anything more than an
ID into a second table to make the information in a first table "connect" to
the second.

Again, I ask, what are you trying to accomplish (not "how")?

 

[steely via AccessMonster.com]

I am currently entering data from research conducted from four different
surveys (which is the reason for the four separate but identical forms). I
would like to keep the separate forms for ease of data entry (e.g. when
entering data all one needs to do is click on the form corresponding to the
survey # on the hardcopy datasheet) and enter the data from that specific
survey. For instance, survey three data would be entered under a form
titled survey 3 and all of survey 3 data would be contained in one separate
table from the other survey data. When entering the data I would like
several fields to autofill so the person entering the data does not have to
fill out fields that will remain the same in all surveys (e.g survey
section, stream, etc...). I like the setup now because if someone wanted
information just about survey 3 I could easily export this information into
excel and it would be separate from the other surveys.....However, I do
realize that it might be more appropriate to enter all the data into one
database and use a sort function to pull out the data I am interested in.
Would you suggest this method instead? Also, If I used this approach how
would I deal with the autofill problem I am having from my previous post.

Thanks for the help.

Steely

 

[Jeff Boyce]

One of my fellow MVPs has created a great tool for handling surveys. Check:

Duane Hookom has a sample survey database at
http://rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Good luck

Jeff Boyce
<Access MVP>