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

set the record source for a main form from a sub form

P: 52
Hello again

Simple one, I hope probably just a yes or no.

I've got a single main form with a continuous subform which has more or less the same info in (the idea being that the main form is for input and the subform is like an embeded dynamic report on a departments spending for a given period).

what I would like to know is, is it possible to pass the ID from the subform back up to the main form, where the viewer can see more detail about the particular order.

I'm sorry if this has been cover in previous posts but I couldn't phrase a search to get the result.

I'm running office 2007, DB is 2003 and os Xp.
Feb 24 '09 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,411
It's possible, but I'm not clear what you are expecting to do with data passed. Do you want to update a control? Do you want to update a variable? Do you want to change the selection criteria of both forms going forward?
Feb 24 '09 #2

P: 52
I'm not very up on the jargon sorry. all I want to do is get the ID for a given record from the sub form so I can build some SQL to get a single record recordset which will display in the main form where all of the detail will show.

The sub and main form are more or less unrelated.
Feb 24 '09 #3

Expert Mod 15k+
P: 31,411
OK. Let me know if you find what you want in Referring to Items on a Sub-Form.
Feb 24 '09 #4

P: 52
Thanks for the article. have got the job done now, but it has thrown up several other bug. ho hum.

Thank you.
Feb 24 '09 #5

Expert Mod 15k+
P: 31,411
Ah well, Good luck anyway :)
Feb 24 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.