473,378 Members | 1,429 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,378 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 4661

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
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...
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: 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
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
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.