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

Weird filtering issue regarding opening form on specified record

100+
P: 374
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

✓ answered by munkee

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

Share this Question
Share on Google+
1 Reply


100+
P: 374
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

Post your reply

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