469,072 Members | 1,840 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,072 developers. It's quick & easy.

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

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
5 1333
32,154 Expert Mod 16PB
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
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
32,154 Expert Mod 16PB
OK. Let me know if you find what you want in Referring to Items on a Sub-Form.
Feb 24 '09 #4
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
32,154 Expert Mod 16PB
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.

Similar topics

6 posts views Thread by Steve | last post: by
2 posts views Thread by Lyn | last post: by
19 posts views Thread by davidgordon | last post: by
1 post views Thread by Oliver Gabriel | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.