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

Populating fields in a pop-up form from a master form

P: 2
Dear all,

(using access 2002 on windows 2k)

Apologies for such a simple question, I just can't seem to sort it out myself.

I have a form called frmProject Details, which includes nested subforms, call logs, contact details etc.

When a user clicks a button, the form frmProject Specific Call Log opens in data entry mode, where they can add details of new activities or calls to the call log (which can then be seen from the subform in frmProject Details).

Why OH WHY can't I get the frmProject Specific Call Log to automatically populate the Project name field with the project that frmProject Details was displaying? AAaagh!

I'm going to have a cup of tea. Thanks so much for the help this board has already provided.
Sep 6 '07 #1
Share this Question
Share on Google+
3 Replies


hariharanmca
100+
P: 1,977
Dear all,

(using access 2002 on windows 2k)

Apologies for such a simple question, I just can't seem to sort it out myself.

I have a form called frmProject Details, which includes nested subforms, call logs, contact details etc.

When a user clicks a button, the form frmProject Specific Call Log opens in data entry mode, where they can add details of new activities or calls to the call log (which can then be seen from the subform in frmProject Details).

Why OH WHY can't I get the frmProject Specific Call Log to automatically populate the Project name field with the project that frmProject Details was displaying? AAaagh!

I'm going to have a cup of tea. Thanks so much for the help this board has already provided.

Just post the version of front-end and what you had tried (<Red Eye>Most important, Get back with that tea</Red Eye>).
Sep 6 '07 #2

P: 2
Just post the version of front-end and what you had tried (<Red Eye>Most important, Get back with that tea</Red Eye>).

The tea must have done the job; so silly, I just put a hidden control on the pop up form with the default value =[Forms]![Project Details]![ID]

Works a treat, and the DB actually looks really nice now. All I have to do is delete about a thousand lines of code from buttons I have subsequently deleted...

So obvious.....Really appreciate the offer of help, though

Don't underestimate the power of tea.
Sep 6 '07 #3

hariharanmca
100+
P: 1,977
The tea must have done the job; so silly, I just put a hidden control on the pop up form with the default value =[Forms]![Project Details]![ID]

Works a treat, and the DB actually looks really nice now. All I have to do is delete about a thousand lines of code from buttons I have subsequently deleted...

So obvious.....Really appreciate the offer of help, though

Don't underestimate the power of tea.
Okay just post what you had tried and
what will do that thousand lines of code and why you want to delete!. Just cleare me.
Sep 6 '07 #4

Post your reply

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