473,545 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Data entry with unbound form and subform

I have made the form with unbound textboxes and comboboxes. after filling the data in the text boxes by user, with the command button called 'add records' the records are transfer to the corresponding table with VB code in the MS access.
This works fine with single form.
But when you try to use the main form and the subform for the two tables data entry with unbound forms and subforms it does work. I need subform in the continuos form. can you please guide me.
Nov 1 '10 #1
1 2967
jimatqsi
1,273 Recognized Expert Top Contributor
Sorry, it won't work in Access. Any unbound object will show the same value in all rows of a continuous form. It's a real pain.

Jim
Nov 1 '10 #2

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

Similar topics

0
1145
by: JH Higgins | last post by:
In Access (.mdb File) I have a subform on a form. Doing data entry on the subform works just fine. If I move the forms and tables over to a .adp I can no longer do data entry in the child fields on the subform. I see the subform's recordset type get's changed to updatable snapshot, but that should be OK. Are there some other properties...
3
2807
by: Carmela | last post by:
Hello Readers, I am trying to update data on a form that is based on a query having a many-to-one-to-many relationship. I found this exciting link that seemed to have the solution for me: http://support.microsoft.com/?kbid=304473 I referred to the part in it that says:
5
5408
by: lottaviano | last post by:
I am using Access 2002 and have two tables (Main and Actions) linked (in Relationships) on one field "CAL_ID" (primary key in Main Table). Main Table is a list of equipment. Actions Table lists actions performed on these pieces of equipment (calibration, cleaning, etc.) so there are many records per every one record in the Main Table. I...
4
1862
by: MLH | last post by:
On a data entry only form. lets say a user opens your form and enters 4 consecutive records. Each time, he clicks your SAVE button and a record is save and the record set is advanced to a newrec. I don't know how to prevent the user from pressing the PGUP key or other keystrokes to back up a record or two. Its not exactly what I want them...
4
2704
by: Robert | last post by:
Have main form with an unbound subform1 which is used for data entry. Subform1 has a nested continuous unbound subform (subform2) which is used to enter multiple records related to the record being entered in subform1. Am using DAO method to save the records entered into subform1 & 2 into the underlying tables (table1 & table2). Record...
2
8113
by: badboybrown | last post by:
Good afternoon, Please can someone tell me the best way of calling up a form that will allow the user to only add new records. I have other forms that will be used to view the existing records. Many thanks. SEAN
1
1814
by: lesperancer | last post by:
I've got a form that is opened in readonly mode and no fields can be changed, great but if I click on a combo box that has an _enter() event that sets a field on my form to a value (albeit the same value it currently has), the form becomes 'dirty' and from that point on, I can changed any data in any field and I checked the .allowEdit...
1
4840
by: BlackFireNova | last post by:
I'm using Access 2003, on Windows XP Pro. I have a subform which is launched from a command button on my main form. When this form opens, I have 2 fields which I have inserted VBA Code into to capture the information in two of the fields on the main form, so I can sync and track the data entered into the subform to the record on the mainform....
1
1244
by: Microchip | last post by:
Hi, all! I have a list of about 100 records, each with only three fields. I want to write a VB6 program to scroll through this list, and edit any of the rows or any of the fields within the rows. I am stuck on the user interface portion. Can anyone suggest a good way to present this data while allowing the user (me) to edit it? I am...
7
9585
reginaldmerritt
by: reginaldmerritt | last post by:
I have a few forms which i have designed to be subforms to a mainform that has no fields or record source. The forms have an unbound textbox and combo box, which i use to seach the data on these 'continuous' forms. Which works fine when i open them as main form. However, as soon as i use them as subforms i can't enter or select anything from...
0
7473
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7661
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7815
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7763
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5976
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
4949
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
1891
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1020
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
712
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.