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

Select current record when expand subset

I've got a subform which has a lookup which is filtered by the value of a record on its main form.

When i expand a record using + the focus can still be on a different row. This results in a wrong lookup.
How can i select the current row when expanding using +?

I'm using Access 2013.
Attached Images
File Type: png screen.png (58.4 KB, 101 views)
Feb 10 '17 #1
1 782
jforbes
1,107 Expert 1GB
I think that is just the behavior of Access and I don't think there is anything programmatically that can be done to change the way Access works when it comes to this. I looked into the OnClick event, but there doesn't really seem to be a way to determine what record was clicked.
Feb 14 '17 #2

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

Similar topics

2
by: aaj | last post by:
Hi all I have a small but rather annoying problem with continuos forms, and am wondering if anyone can suggest a method of getting over it. The front end is Access 2002 with the BE being SQL...
1
by: Tony | last post by:
I have a form in access that has 5 fields for a certain record: 1)Date mailed, 2)Date received, 3)Date completed 4)Foreign Content amount and 5)record number. If the foreign content (FC)is >15% of...
3
by: hebandgene | last post by:
When I delete a record in a subform I get the warning that I'm about to delete a record, followed by an error "No current record." When I click OK obviously the record is deleted and it goes to...
2
by: capdownlondon | last post by:
using ACCESS 2003 This code should do what I want, and it seems to, but every time i run it it says: No Current Record when i ctrl+break it the debug get hung up on the end sub. heres the...
2
by: solargovind | last post by:
Hi... Can anybody sugguest my below case..? When i open form either in Form View or Datasheet view, the form should come & stand current record. b'cos My user alter the data in previous record...
1
by: THEAF | last post by:
i'm trying to create a reminder form, when i add a new reminder its ok but when i try to delete a reminder then i get No Current Record problem. Form Load Private Sub Form_Load() Dim s() As...
5
by: Jamen98 | last post by:
I'm running into a problem with running multiple queries. I have two tables that look like: Risk_Mgmt_Table Fields: (Values) Filing_State: (CA) Membership: (Yes) Membership_Rate: (.95)...
8
sueb
by: sueb | last post by:
I have a form (which is used as a Continuous subform) that has a button on it that calls up a separate, more detailed form for the the particular record's. However, I want that button to appear only...
14
by: AndyB2 | last post by:
I am trying to assign a temp variable in a while statement. I know row 30 is wrong "Where MachineName = MachineName ....". But if I'm on record 251 before I head into my Select statement (row 27)...
15
Psylence
by: Psylence | last post by:
Good afternoon everyone ~ Let me first begin by saying I am not a programmer in any way. I took over a position that included data entry on Access 2007 running on Windows XP but the original...
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: 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?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

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.