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

Passing unbound form field into subform

P: 48
I am designing a form with subform. One of the subform items needs to be separated from all the rest (purely for look, unfortunately), and so I have an unbound field (Date) in the form itself. After update, I need to pass the value of Date to the subform subDate field.

I'm guessing VB is the best way to do this, but it doesn't seem to like any of the statements I've tried using so far. How does one refer to a subform from a form?
Aug 3 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,359
If it's purely for look and not any functional purpose then you should be able to replicate it without having to use a subform. What look are you trying to achieve?
Aug 3 '07 #2

P: 48
The look wasn't my idea, I just need to follow the exact layout of a paper version of the form.


I found a great tutorial on this:
http://blogs.techrepublic.com.com/msoffice/?p=188

I figured I'll leave the thread in case anyone searches for it in the future.
Aug 3 '07 #3

Rabbit
Expert Mod 10K+
P: 12,359
The look wasn't my idea, I just need to follow the exact layout of a paper version of the form.


I found a great tutorial on this:
http://blogs.techrepublic.com.com/msoffice/?p=188

I figured I'll leave the thread in case anyone searches for it in the future.
I understand that, I'm just saying you can probably achieve the same look without resorting to a subform.
Aug 3 '07 #4

P: 48
Howso? The data needs to be stored in two separate places, and the subform data needs to be accessed and managed while viewing the form data...
Aug 6 '07 #5

Rabbit
Expert Mod 10K+
P: 12,359
Howso? The data needs to be stored in two separate places, and the subform data needs to be accessed and managed while viewing the form data...
So then there is a functional purpose. You said it was only for looks. The functional purpose then is to store data in two different places.
Aug 6 '07 #6

Post your reply

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