473,326 Members | 2,110 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,326 software developers and data experts.

Subforms / Event procedures

Hi,

Looking at the template "Order Entry" in Ms Access, how do you get
the following to work?

In the customer form there is a sub-form giving a summary of orders by
customers. After entering an order for a custom it displays here.
When you double click on an order id it opens another form and lists
the correct record by order id

I can get the double click to work but cannot get the correct record to
show up.
It always shows up the first record. I know it has something to do with
putting SELECTROW in the data source and having event procedures in the
OnOpen, OnActivate and OnCurrent fields.

Can anyone offer help on how this works, ie what needs to be in each
event procedure, or somewhere that I can get a tutorial on it. Is there
a name on this type of thing.

Regards,

Denis

Jan 22 '07 #1
4 2052
Baz
DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " [order_id]

"Denis" <de*********@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
Hi,

Looking at the template "Order Entry" in Ms Access, how do you get
the following to work?

In the customer form there is a sub-form giving a summary of orders by
customers. After entering an order for a custom it displays here.
When you double click on an order id it opens another form and lists
the correct record by order id

I can get the double click to work but cannot get the correct record to
show up.
It always shows up the first record. I know it has something to do with
putting SELECTROW in the data source and having event procedures in the
OnOpen, OnActivate and OnCurrent fields.

Can anyone offer help on how this works, ie what needs to be in each
event procedure, or somewhere that I can get a tutorial on it. Is there
a name on this type of thing.

Regards,

Denis

Jan 22 '07 #2
Baz
Sorry, finger trouble, that should read:

DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " & [order_id]
"Baz" <ba**@REMOVEbcap.THEeuro1net.CAPScomwrote in message
news:45***********************@news.zen.co.uk...
DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " [order_id]

"Denis" <de*********@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
Hi,

Looking at the template "Order Entry" in Ms Access, how do you get
the following to work?

In the customer form there is a sub-form giving a summary of orders by
customers. After entering an order for a custom it displays here.
When you double click on an order id it opens another form and lists
the correct record by order id

I can get the double click to work but cannot get the correct record to
show up.
It always shows up the first record. I know it has something to do with
putting SELECTROW in the data source and having event procedures in the
OnOpen, OnActivate and OnCurrent fields.

Can anyone offer help on how this works, ie what needs to be in each
event procedure, or somewhere that I can get a tutorial on it. Is there
a name on this type of thing.

Regards,

Denis


Jan 22 '07 #3
Where do I put that line

Denis
Baz wrote:
Sorry, finger trouble, that should read:

DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " & [order_id]
"Baz" <ba**@REMOVEbcap.THEeuro1net.CAPScomwrote in message
news:45***********************@news.zen.co.uk...
DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " [order_id]

"Denis" <de*********@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
Hi,
>
Looking at the template "Order Entry" in Ms Access, how do you get
the following to work?
>
In the customer form there is a sub-form giving a summary of orders by
customers. After entering an order for a custom it displays here.
When you double click on an order id it opens another form and lists
the correct record by order id
>
I can get the double click to work but cannot get the correct record to
show up.
It always shows up the first record. I know it has something to do with
putting SELECTROW in the data source and having event procedures in the
OnOpen, OnActivate and OnCurrent fields.
>
Can anyone offer help on how this works, ie what needs to be in each
event procedure, or somewhere that I can get a tutorial on it. Is there
a name on this type of thing.
>
Regards,
>
Denis
>
Jan 22 '07 #4
Baz
When you said that you had the form opening already, I presumed that meant
you already have a DoCmd.OpenForm statement. If so, simply replace it with
the one I gave you, it should be in the OnDblClick event.
"Denis" <de*********@gmail.comwrote in message
news:11**********************@q2g2000cwa.googlegro ups.com...
Where do I put that line

Denis
Baz wrote:
Sorry, finger trouble, that should read:

DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " & [order_id]
"Baz" <ba**@REMOVEbcap.THEeuro1net.CAPScomwrote in message
news:45***********************@news.zen.co.uk...
DoCmd.OpenForm "frmSomeForm",WhereCondition:="order_id = " [order_id]
>
"Denis" <de*********@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
Hi,

Looking at the template "Order Entry" in Ms Access, how do you get
the following to work?

In the customer form there is a sub-form giving a summary of orders
by
customers. After entering an order for a custom it displays here.
When you double click on an order id it opens another form and lists
the correct record by order id

I can get the double click to work but cannot get the correct record
to
show up.
It always shows up the first record. I know it has something to do
with
putting SELECTROW in the data source and having event procedures in
the
OnOpen, OnActivate and OnCurrent fields.

Can anyone offer help on how this works, ie what needs to be in each
event procedure, or somewhere that I can get a tutorial on it. Is
there
a name on this type of thing.

Regards,

Denis

>
>

Jan 22 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: M Wells | last post by:
Hi All, I am developing an Access 2003 project application with the back end in SQL Server 2003. I have a master form that tracks projects, and several subforms on it that track various...
3
by: Diana Gard | last post by:
Perhaps this is a design flaw, please let me know. I'm using Access 2000. I have a form with a tab control and 5 subforms within those tabs. The forms match with the tables: Client main,...
3
by: R Millman | last post by:
under ASP.NET, single stepping in debug mode appears not to stop within event procedures. i.e. 1) Create web page with submit button and event procedure for the click event in the code behind...
2
by: tlyczko | last post by:
I have a main form with 2 subforms, each subform references different data in the same table. How do I make sure each subform only creates NEW records in the referenced table and do not...
4
by: microb0x | last post by:
I have an application with a master form with a tab control containing nine tabs, each tab contains a subform. I have command buttons on my main form including: Save , Cancel , Close. My...
2
by: robert.waters | last post by:
Hello, If I have a form containing a Tab Control with N pages, each page containing a subform, are those subforms loaded into memory when another page has the focus? I have tried iterating...
0
by: TD | last post by:
I have a main form with two subforms (both in datasheet view), neither of which are linked to the main form. The main form is based on a query that uses the bound column of a combobox on the main...
3
by: 6afraidbecause789 | last post by:
Think school - students - discipline interventions - misbehaviors - staff for this one....On a mainform frmStudentInterventions, I have linked a subform (sfrmMisbehaviors) with another subform...
5
sickenhoofer
by: sickenhoofer | last post by:
I have a form w several subforms. The ultimate goal would be to click on a location, and have the data in the other subforms change to the data specific to that location. For this form, there are...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.