By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Looking up information

P: n/a
Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I
need to be able to have multiple combo boxes, one from each table.. and
have them all share one field for displaying the chosen record.

Can anyone tell me if this can be done or not? If it can... how?

Thanks
Victoria

Jan 13 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 12 Jan 2007 18:30:49 -0800, "Torilyn73" <to*******@gmail.com>
wrote:

Only if you explain better. Remember, we have never seen your db
design, and don't even know the topic of your app.

If you want one form to display data from several tables, that can be
done by changing the RecordSource. Or by having a subform and changing
the SourceObject of the subform control.

"I can only have one field that shows the record selected": that
confuses me. What do you mean? Typically a record has several fields.

-Tom.
>Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I
need to be able to have multiple combo boxes, one from each table.. and
have them all share one field for displaying the chosen record.

Can anyone tell me if this can be done or not? If it can... how?

Thanks
Victoria
Jan 13 '07 #2

P: n/a
Sorry.. I didn't explain very clearly. I have solved my problem
though.. thanks!

Tom van Stiphout wrote:
On 12 Jan 2007 18:30:49 -0800, "Torilyn73" <to*******@gmail.com>
wrote:

Only if you explain better. Remember, we have never seen your db
design, and don't even know the topic of your app.

If you want one form to display data from several tables, that can be
done by changing the RecordSource. Or by having a subform and changing
the SourceObject of the subform control.

"I can only have one field that shows the record selected": that
confuses me. What do you mean? Typically a record has several fields.

-Tom.
Ok... I'm stumped here. I am trying to do something that I am not sure
I can do. I have a several tables of data. I need a form that I can
access this stuff easily, no switching back and forth between screens
or windows. I can only have one field that shows the record selected. I
need to be able to have multiple combo boxes, one from each table.. and
have them all share one field for displaying the chosen record.

Can anyone tell me if this can be done or not? If it can... how?

Thanks
Victoria
Jan 16 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.