473,382 Members | 1,665 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,382 software developers and data experts.

ms access linking forms

5 Nibble
'Form fmLog2File is paired with fmLogFile by code as follows:

Private Sub Form_Current()
Dim Form As Form

Set Form = Forms("fmLogFile")
Form.Filter = "logID = " & Me!logID.Value & ""
Form.FilterOn = True
End Sub

'The same form fmLog2File is paired with fmLogOp by similar code as follows

Private Sub Form_Current()
Dim Form As Form

Set Form = Forms("fmLogOp")
Form.Filter = "logID = " & Me!logID.Value & ""
Form.FilterOn = True
End Sub

'My idea is to avoid 2 pairs of forms and 2 pieces of similar code, e.g. one piece of code which will link fmLog2File with 2 other forms simultaneously. Can you help me out with this please?
Mar 23 '22 #1
0 4668

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

Similar topics

0
by: Ashish_khanna | last post by:
I have an MDI form. from here i am opening my child forms by creating objects. Plz tell me how to make single instance of these forms. and how to access ActiveMDI forms public methods
1
by: Simon | last post by:
Hello All I am trying to build a couple of forms in Access 2000. Whilst I have one form which has all of the contact details in it also generates (using autonumber) a unique id for the customer....
2
by: gthompson | last post by:
I'm redesigning my Access Form in Visual Studio (asp.net) so that I can have a Web application connected to the Access Database. It is a user form. Is there any way to have a subform in Visual...
4
by: Thelonious Monk | last post by:
Is it possible to convert Microsoft Access 2000 forms and import them into a Visual Basic .NET project? This may be a far-fetched question, but it sure would be nice to do. Thanks!
1
by: santociabattari | last post by:
Hi Folks, I have 3 forms I want to link, so that when I advance 1 record in one form it will update the other two with the same record in the first form. I have tried using the form wizard (I...
2
by: danthrom | last post by:
Hi all, I am trying to hid a command button which links two forms. The forms are connected by a one-to-many relationship and the second form has details on the first. But if no details are...
5
by: oldroboman | last post by:
I have an access 2003 app, it has a main form, and a linked subform, the main and subforms are linked on one field, what I am trying to do is, when the user selects an item in the subform, and then...
2
by: walt | last post by:
Just converted from Office 2000 to Office 2007, after ran into to a few problems (lack of understand being the bigs problem) but the one I can't overcome is, in access 2000 forms I could display ...
6
by: twinks | last post by:
Hello! I have created one form "A" from Table A with buttons that lead to other forms ("B", "C", "D") - with respective Table B, C and D. I'm trying to link the request ID of form A with the...
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...
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
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.