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

Basic Doubts in Creating Subform

Hi,

I am New to this forum. I need steps that i do in creating subform.

In main form, i have one table fields like vendor,account,due amount,balance amount and Requisition_id which is autonumber field.

I tried to create subform by using table or that table's form which are having autonumber field and this is to be linked with Mainform autonumber field(requisition_id).

But the following errors comes.

"You can't assign value to this object"
-The object may be a control on a read-only form.
-The object may be on a form that is open in Design View.
-The value may be too large for this field.

I checked above three correction, but everything is correct.

Now, i want to be sure in creating subform. So, now my doubt is..

-What are the steps should i follow to create subform?
-What are the condition should be checked?

And, even when i checked in the table, the Autonumber field(Requisition_id) should have '+' symbol which shows related information. But, there is no such a symbol. It may be relationship problem. If it is relationship problem, how & where i should create relationship.

Totally, I am embarracing myself with creating Subform.

Hence, Can anybody describe me the use of subform with one small example CLEARLY..?

Thanks in advance.

ngr.
Apr 13 '07 #1
3 1773
MMcCarthy
14,534 Expert Mod 8TB
To create a subform design the form first from the table that the records will be pulled from.

Then open the main form in design view and drag the subform tool on to the form. A wizard will open asking you to chose which form to put in the subform. Chose the one you've just created.

Step through the wizard and it will prompt you for the connection.

Mary
Apr 13 '07 #2
To create a subform design the form first from the table that the records will be pulled from.

Then open the main form in design view and drag the subform tool on to the form. A wizard will open asking you to chose which form to put in the subform. Chose the one you've just created.

Step through the wizard and it will prompt you for the connection.

Mary
================================================

Hi,

Thanks for your information. The thing which you told already done in the same way. But shows some errors which i needed to clear.

Anyhow...I found myself the error. The problem is linking the field between main form & subform.

Now its working fine.

Thanks a lot...

ngr.
Apr 14 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
You're welcome.
Apr 14 '07 #4

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

Similar topics

3
by: Bruno Luis | last post by:
Hello I'm using A97 and i'm having some trouble with creating a recordset with data from two different databases. I connect to a remote database and make this data the default source for my...
14
by: alwayshouston | last post by:
Hi All! I am working on this very small database and I am confused in the designing a simple form. I only have three tables in the database. First Table: tblExpense Columns: ExpenseID ;...
4
by: jmarr02s | last post by:
I am using Access 2003 and am having difficulty creating a subform that will save records associated with a particular parent record.... The error message I receive pertains to indexes,...
7
by: ppywong | last post by:
Hi, hopefully people can help: I am creating a rather simple database for a kids holiday camp. I have two main tables: tblLData (Leaders info) and tblKData (kids info). What I have done is...
0
by: tebza | last post by:
I have a problem with creating a subform in visual basic.net. how is created
4
by: aflat362 | last post by:
If you look at this page on relational database design: http://r937.com/relational.html And scroll down to the "Many-to-Many Relationships" Section you will see a common database structure. ...
3
by: dancole42 | last post by:
I have an InvoiceLines subform on an invoice table. In the subform, I have the following fields that are bound to the actual InvoiceLines table: Class (the type of product) Product (the...
3
by: robertoathome | last post by:
Hello, I successully adapted a search form from a microsoft example into my own db. MS Example I type search parameters in 2 boxes and the results are returned in a new, basic query window. ...
4
by: rczuba | last post by:
Problem: Creating a Default Value for a field in a subform when a field in the subform & form match. I'm trying to create a payroll database for a small home business that I have that has had...
0
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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...
1
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....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.