473,387 Members | 1,650 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

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
3 1192
hariharanmca
1,977 1GB
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
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
1,977 1GB
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

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

Similar topics

1
by: David Shorthouse | last post by:
HI is it posible to auto populate an access database.? I have 1 table structured Index_ID. - Index & auto number First_Name - Char50 Surname - Char50 Initals - Char50 Postcode - Char50...
0
by: David P. Jessup | last post by:
Background info: I'm attempting to populate an array with specific column numbers from a database. I have another array(from a linked table) that has matching column names from the original...
1
by: cloverme | last post by:
Hi, I need help populating a listbox from a database on a webform. I created a an access database with a table, fields and data. Then I created a WebForm in vb.net and added a DropDownList...
0
by: elcc1958 | last post by:
I need to support a VB6 application that will be receiving disconnected ADODB.Recordset from out DotNet solution. Our dotnet solution deals with System.Data.DataTable. I need to populate a...
1
by: MrB | last post by:
I am quite new to vb.net. I have been using VBA for years, but an having problems with populating a listview. I have tried many things, including snippets of code from some news groups with no...
3
by: Sidney Linkers | last post by:
Hi, I'm trying to make a calculated text field in a query where the textvalue is being populated from multiple records. I already use a VBA function to loop through records and concatenate the...
1
by: Svelte Poshy | last post by:
Populating a field in a table depending on another In my table customers i want to populate the field segmenid depending on the choice in the lookup field Typeid. Both fields, typeid and...
0
by: Joe Kelb | last post by:
I have an Excel spreadsheet with two fields of data, part number and product code (hundreds of lines of data). The same fields of data are in a database, however the product code fields are empty....
1
by: Patrick | last post by:
Am upgrading an application from VB6 to VB.Net. One of the controls is a ListView that am failing to populate. Am including some of the code for some assistance where I may be going wrong. Private...
0
by: MR | last post by:
i am writing an application that automates the process of loading a web page, login into a site and then simulates the navigation of the site. the program uses a winform with a webBrowser control...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.