Hi
All:
Although I'm not new
to Access I'm stumped on this one. If you can help, Please keep in mind I mainly
use wizards and any reference to VB should be worded "for the complete idiot".
Thanks. I'll try to keep this simple:
1). I have two
tables. One with 10 columns.
2). I have a
form with 1 drop down box and 9 fields.
3). The drop down
box selects one record from table "A" with the "key" being the selected
field filler.
4). After fields on
the form are populated they need to be saved as a new record in Table "B" (Along
with some other unmentioned typed in info)
I would like to
populate the remaining fields with the data from the other columns. I have no
problem filling in the field on the drop down box BUT, I need the syntax
AND method of
finding the remaining column fields and sticking it in the form fields.
Here's a simplified example:
col1 col2
col3 col4
col5
data1
data2 data3 data4
data5
key
===========================
Form:
Field1 Dropdown box
(selects field1's data "key")
FormField2 should be
data2
FormField3 should be
data3
etc........
And ALL should be
saved into table "B"
Can anyone
help....
Thanks
=Dave
R.=
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
| Microsoft access developer | Microsoft access help | Microsoft access database |
| Microsoft access training | Microsoft access training course | Microsoft access programming |
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
