Link Two Forms Together On One Field In Add Mode
Hello!
I Have a
project form
test form
sample form
for 1 project there are n tests and for 1 test there are n samples.
The project form is alone and has a button to open the related tests in the test form. The test form incorporates the sample form as a subform.
What works:
For entries already in the database when I click the related tests button on the project form it opens the test form filtered in the correct manner.
For the test form the sample form displays and increments correctly.
What doesn't work:
When I open the project form in add mode I fill in the data and when it is done I click the related tests button and the linked/child field isn't there! No data, I can't get it to work...
Can you suggest something?
PS I cannot find anywhere in the Data properties the Linked field properties... neither child nor parent?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Passing Variables Between Forms In Shared Mode
Before I go any further w/this current application, I want to make sure this will work. I have an access database w/a few forms that will sit on a shared drive on a network. Each user will also have their own username and password because each user will have a certain level of access to what they are allowed to see. The problem I am facing is that if I put the users ID into the global variables module, and two users log on at the same time, then access seems to somehow use both of the IDs when running queries. This makes sense that all uses can see it, since it's Global... but I need a way for simultaneous users to have a persistant unique id so I can query data that's only meant for them. I found this example of code that might remedy the situation by passing variables between the forms. Call the code below in frmOne to pass the variable. DoCmd.OpenForm "frmTwo", acNormal, , , , acWindowNormal, "Count=2" Call the code below in frmTwo to get the variable. Dim i as Integer i = CInt(GetTagFromArg(Me.OpenArgs, "Count" )) Will I end up w/the same result? Will all users be able to see this variable as well?
View Replies !
View Related
Linking A Field To Another Field In Tabular Mode
Hi, I'm new to access and I have a form displaying fields in tabular mode. I have two fields that are drop down lists grabbing their data from queries. What I need to do is to link one field to the other so that once the first field is changed, the other one is updated (the first field shows the list of companies and the second shows the list of projects for the selected company). I tried to do this using the "Change" event but once I try to modify the query of a control, it's modified on all the records rather than only the current record. Is there anyway I can accomplish this? Thanks in advance Sarmad
View Replies !
View Related
Link Forms
Hello everybody, I have one dbase with 3 tables wiht 3 forms. One is "custonmers" , "glass" and "lens". Customers - CusID as primary Keys Glass - GlasID and CusID primary keys Lens - LensID and CusID Primary Keys When I change a specific field (only) I am losing the records on the other tables of the specific customer. Thanks in advance xxx ΠΑΟ ΘΡΗΣΚΕΙΑ ΘΥΡΑ 13
View Replies !
View Related
Link Forms
Mornin, all... I have several forms, all tied to the same table. The PK for the table is ObjectID (an auto number field). The reason for so many forms tied to the one table is, I'm using them as "wizards" to explain the types of information and give some examples. So, on Form 1, I have the PK and Description (a memo field). On Form 2, I have the PK and Objectives (a memo field), etc. I want to be able to click a button on Form 1 which will close Form 1 and take me to Form 2, same record (creating a new record with the same ObjectID). However, Form 2 continues to create a new record in the table. Can someone help me with this, please. Thanx so much ;<)
View Replies !
View Related
Link Between Forms
ALREADY SOLVED The pictures say it all I already know I need to change something at control source but I always seem to be getting #error in the box instead of the value. Edit: After screwing around some more I found what the problem was. In the expression builder I reffered to the wrong field. Apparently the name box was named Text125. That'll teach me to not name my fields properly
View Replies !
View Related
Link Related Forms
I have two tables (table1,table2) with one-to-many relathionship between them. Form1 has table1 as Record source and form2 has table2 as record source. I connect these two forms with a command button. How can i get to form2 only the records that related to form1 record? Thank you in advance:)
View Replies !
View Related
Command Button To Link Forms
Alright I give up. I searched the forums and read up but still not grasping it. I know I've done something like this before but my brain must be dead today. So I have 4 important tables. I have a main one and 3 tables that have records related to the main one. They're all the "many" sides of the one to many relationship with the main table. Outline is below: Main Table: EMP_ID (Primary key) ...and other fields Employment Table: HIRE_ID (Primary key) EMP_ID (for relationship) ...and other fields Insurance Table: INS_ID (Primary key) EMP_ID (for relationship) ...and other fields Skill Table: SKILL_ID (Primary key) EMP_ID (for relationship) ...and other fields So basically what I'm looking for is to have a main form pop up that has the Main table information (employee info). Then on that form I want 3 command buttons, each one going to a new form that relates to the three tables above and is relative to the Main table. Each employee may have several hire/fire listings, insurance listings (if they change their insurance), and skill ratings (updated as they improve). When I have set all my relationships so that the EMP_ID on the Main table has a one to many relationship with all the EMP_IDs on the other tables. When I create the command buttons though and start to populate a record in one of the three "subforms" the EMP_ID is not populating to be the same as the EMP_ID from the main page thus making me unable to create a record because it doesn't recognize a related record. What the heck am I doing wrong
View Replies !
View Related
Link One Field To 3
I have a database which works as an information system for the upcomming olympics. In tblAthletes is... AthleteID (Primary Key) FirstName Surname And Various other fields not needed in this problem In tblResults is... Gold Silver Bronze Also other field in this table What I am aiming for is to have Gold AND Silver AND Bronze all as foreign keys of the AthleteID field. Is there a way to do this or can another way be suggested. I am working on the 2000 version of access.
View Replies !
View Related
Tab Control With Subforms / "Can't Build A Link Between Unbound Forms" Error
I am trying to create a database for a cub scout pack that just keeps scouts information, medical info, parents info, and parents medical info each is a seperate table. I have created a Tab controlled form with 4 tabs. On each tab the ONLY thing I have is a subform that contains the appropriate information. Each table has it's own form with the table as it's record source. I link the scouts table to the medical table by SID which is a primary key in the Scouts table. I link the Scouts table to the Parents table with a PID which is the Primary Key in my Parents table, and I link the Parents with the ParentsMed with a PMedID, key in the ParentsMed table. Question #1 - Using a Tab Control you can only have 1 record source. What should I use? I have tried the tblScouts and I have also created a query with every field from every table. #2 - When I try to use the parent and child links on the subform I get the error "Can't build a link between unbound forms" but each form is bound to the table and the record source on the tab control has had a table and my qryEverything, neither work. I can type in SID but it still doesn't function properly. Any suggestions or comments on a better relationship method or any insight on how tab controls are supposed to be setup or anything would be greatly appreciated. Thanks a lot Rick
View Replies !
View Related
Field On Subform Link With Form
hi i have a form just like customer orders in Northwind with 2 subforms Subform1 is showing orders number and i want to add something on that subform 2 is products that ordered ! i want to add something on subform1 that if i Dbl Click on orderID field it will sho for example another Form "orders" i'm trying this code but i can't do it Private Sub OrderID_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "orders" stLinkCriteria = "[OrderID]=" & "'" & Me![OrderID] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit Sub End Sub would u please help me
View Replies !
View Related
Unable To Link Subform With Memo Field?
I have a form/subform that I want to link together using a memo column, yet when I try Access tells me that the column datatypes are incompatible. I've even tried making both the form's and subform's recordsource be the same table. Any idea how I can do this?
View Replies !
View Related
Field Lookup On Forms
I am a new Access (2003) user. I am using one table (Table A) as a data source for a form, using the form to update and edit records. However, I wish to include a field on the form that uses an ID field in Table A to perform a lookup on Table B. To explain further, I have a staff ID in Table A, and I want to look up and display, but not edit, the corresponding surname from Table B (just for display and convenience - we all recognise surnames rather than ID's). Many thanks in advance
View Replies !
View Related
Field List In Forms
All, I wish to create a custom form to link into my tblData table, however when I open a form in design view, the field list is not displayed. I have tried to select it from the toolbar but the button is not available ('greyed out'). I know I have done this before but can't remeber how. Any help please would be great? JB
View Replies !
View Related
Autonumber Field In Forms?
Hello- I am trying to create a database for a non- profit. They have events and workshops and want a numbered field for each entry in their registration form. Seems like a simple thing to do, but Im not figuring it out. Is there anyway to put an unbound field in a form that will autonumber each entry? Thanks for any help!
View Replies !
View Related
Populating The Same Field In 2 Forms
I have 2 forms. Information from one field links both forms (though it is not the primary key). Using a "open form" button I want the field on the second form to be populated with the contents from the same field on the first form, when a user selects the open form button. I imagine all of this is very doable in SQL, however I am using Access GUI to construct my database and have no time to learn SQL at this stage. Any ideas would be greatly appreciated.
View Replies !
View Related
FORMs Not Recognising A New Data Field
I have been using an Access database to manage my contacts for about ten years now. I have often updated the table by adding new data items (fields) with no problems. I have updated the associated FORMS, and the new data item(s) have always been visible to the forms. Today, I tried to add a new field to the table, which was apparrently successful, but when I try to modify the associated FORM to enable data entry to the new field, the FORM does not see the new field. If I produce a totally new FORM, the new filed is visible to it. What has changed? I am using XP SP2, with ACCESS 2002 SP3. I have tried all the tricks I know, but I cannot solve this one. Help, please!
View Replies !
View Related
|
TRACKER
