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

Form and subform, carry field values from

1
I have two tables in a single database that I just linked in a one to many relationship. I created a main form with a subform, with the One table as the main form, and the Many table as the subform. I did this primarily to make data entry simpler. Prior to this, data from a single data sheet were entered into two different forms, one for each table, sharing a single field that related them for joins, etc., without an existing one to many relationship. The resulting main form and subform work, however, my problem is that I have been unable to carry over field values from the main form to the next record in the main form. I used this code segment with a single field as a test:

Private Sub STATION_AfterUpdate()

Me.[STATION].DefaultValue = Me.[STATION]

End Sub

When I move to the next main record the STATION field in FORM view contains #Name? I'm sure this is a common problem but I haven't been able to solve it. As I have numerous records that will not change from one record in the main form to the next, any help would be greatly appreciated. I also have two fields in the sub form that I want to carry over from one sub record to the next also.

Thank you
Nov 15 '21 #1
0 6990

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

Similar topics

1
by: David | last post by:
Hi, I have an ASP page with a form and the following code: ..... type=Radio Checked name=selectserial value=" & RS("PSL_F_Serial")..... Tis will carry over the value of RS("PSL_F_Serial"),...
1
by: bdt513 | last post by:
I am trying to extract the values from a query using VBA. Specifically, I want to concatenate all the values of the "rosEmail" field from query "qselRosterEmailList" into one string (strEmails). I...
1
by: vikram | last post by:
What is the best way of transferring values from one aspx page to another when user click a button, except response.redirect and server.transfer.
3
by: prabodhtiwari | last post by:
function submitPartsForm(str) { var count=document.getElementsByName("partId"); for(var i=0;i<count.length;i++) { document.mylist.myNum.value= document.getElementsByName("partNum")...
3
by: Bjorn Sagbakken | last post by:
What is the best way to read single field values from a dataset? The dataset is populated with a customer record, showing well in a gridview. But I also want to read the single field values, like...
2
by: NicotineJones | last post by:
Hi, I have database with monthly sales data tables within it. These sales data tables are organised as follows. Item code; Description; Country1; Country2; Country3..etc 1234; Item1; Sales...
3
by: ejamnadas | last post by:
I have a form which combo boxes (say cmb1 and cmb2). The form also has a subform with a listbox whose rowsource is a query based on the values selected in the comboboxes. In the After Update event...
1
by: vinod kadam | last post by:
I have make php mysql login system all system is worked well.But our client require the login from his system to another website. So that website admin give us secure url that verify the username and...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

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.