473,587 Members | 2,230 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Weird filtering issue regarding opening form on specified record

374 Contributor
I have a sub form within my main form which displays all records from a table in an overviewed format. Within the design view in the sub form I added a "View full record" button. When you click this it opens up a form which displays all the detail of the record so you can see the complete information after briefly seeing the overview on the previous form.

I used the open form wizard when you select the open form command button from the toolbox to link the ID number from the displayed record in the sub form to the ID number of the full record in the new form.

This has worked perfectly fine when using it on other pages however when I click it on the sub form page it just displays a new record.

Funnily enough though if i keep this form open as a popup and click View Record in Full on the previous form it loads the record in to the form correctly, as well as all the others as I click through them.


Any idea why the form keeps opening to a new record? When I view the pop up form properties it even shows the filter being set to the correct ID number :| I dont understand why it wont show the record. Data Entry is set to false.
Jul 12 '10 #1
1 1214
munkee
374 Contributor
My bad, I didnt think to check over my onload event of the form being opened. I had it open to a new record if the filter was off but I had messed the code up and told it to do that if the filter was on.

Sorted now
Jul 12 '10 #2

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

Similar topics

3
11094
by: Jason | last post by:
I am trying to filter records in a primary form based on records in related tables. The data in the related tables is being displayed in the primary form through subforms. To be more specific, I have a primary form named TestResults, which is connected to data in a table named TestResults. There are basically two other tables that are...
5
3069
by: Richard | last post by:
Hi, I have a form that take some time to load due to many comboboxes and at least 8 subforms. When I filter or sort the main form I get an error message and then Access shuts down. They ask if I want to send the error report to Microsoft. Has anybody seen this type of error message and what can I do to prevent it from happening. Am I doing...
2
1275
by: Daniel Hidalgo | last post by:
Hi, I have an issue that I am trying to resolve. I am populating a list box with employee names and would like to have the capability for a user to open an employee record by double clicking on the emplpoyee name in the listbox. Is this possible to do? Thanks, Daniel Hidalgo
3
5014
by: Simon Rowe | last post by:
Probably really simple but I cant work it out... I have a list box on a form with a few records in. When I open the form the first record is sort of highlight with a dashed box, when I cursor down the record changes to inverse video and from then on I can sroll up and down the records with the inverse video highlight. I just cant seem to...
22
5013
by: Br | last post by:
First issue: When using ADPs you no longer have the ability to issue a me.refresh to save the current record on a form (the me.refresh does a requery in an ADP). We usually do this before calling up another form or report that uses some of the same data. We came up with a work around that saves the current record's ID, does a
2
1170
by: Bruhah | last post by:
Here is my issue: Have an Quality Issues database. Created a query to pull only those issues still left "open". Tied a list box to display the data pulled in the query (Issue, Date of Issue, Who is Responsible, etc) Where I am having trouble is I would like for them to be able to click on the issue in the list and it will take them directly...
10
1617
by: JHNielson | last post by:
I have three related questions for an update form I'm building and hope someone can help: I have a table called and I want people to be able to review those records and if they need to update them. I have made a form for viewing the records. 1) The first question is how do I make a drop-down menu of the (the primary key for the table) ...
7
4934
by: chrismaliszewski | last post by:
Hi. I created code which makes dynamically form with bounded controls for all columns. I show it to you below. My problem is, how I have to change this code to create form which record source are few (e.x. 2) tables? Thank you for help If you want to use this code, you only have to change value of: - nazwaTabeli (table's name of...
3
1602
by: James Bowyer | last post by:
I am trying to use a listbox in a form to go to a specified record in the same form. I have tried the following code, but it keeps saying "Can't go to specified record" If IsNull(SiteList) Or Me.SiteList = "" Then MsgBox "Select Site From List", vbExclamation, "SCM" Exit Sub Else Dim GotoIdNo As Integer GotoIdNo = DLookup("",...
0
7843
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8205
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8339
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7967
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5712
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5392
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3840
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3872
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2347
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.