Form prob...

[johnzila]

I got a prob with a continuous form

There are 10 fields in the form...
All are using an SQL statement to retrieve,
except for 1 fields which i manual create to catach user entering of data.
But whenever a data is input to the field, it automatically admend all the other records to the same value.
Wat shd i do

 

[Pat Hartman]

Tables store data, not forms. Your control is unbound. Therefore it can have only a single value. If you want to store a value for each record, you will need to add a column to your SQL table or create a local Access table to store the value.

 

[johnzila]

i am sorry.i dun really get u.

I use a Insert query to add the items on the screen to a table

the prob is with tat unbound fields.
Let's say i enter a 12 for the 1st record, the following record all will automatically change to 12...
y is it so even if i nv enter for the other?

 

[WayneRyan]

John,

Access offers a continuous form to let you easily scroll through a
recordset. Access does all the work of keeping all of your "bound"
data in synch.

In your form, the controls are not "bound" to your recordsource. Access
will not attempt to police your unbound data. In design view, when you
are defining a textbox, you are defining only ONE entity. You reference
it be some name. Access won't interfere with you, it will just replicate
your "unbound" object within each "record" (well, sort of a record).

Wayne

 

[johnzila]

Thx...
So how do i solve it?

 

[WayneRyan]

John,

Basically, if you use an "unbound" form, you can't have a continuous form.

I would "shelve" the unbound form, it really is a LOT more work for you in
the long run to recreate what Access already does.

Wayne

 

[johnzila]

ok...so u mean i dun do the continous form things?

ok i got this prob i wana ask...

i use a SQL to select some fields out from a table

e.g item_number from Inventory table

i put into a form e.g Item

then i add another filed in the form e.g. quantity

Thus i wan to save the item_number and quantity to a new table...

How do i do it?
Need i the code?

 

[Pat Hartman]

Create a query that selects the fields you want from the table or tables. Then use the form wizard to build the form. Just be sure to choose the query you just built. No code will be written. All the updating/scrolling/etc. is handled automatically by Access when the form is bound to a table or query.

PS, Please tell me that English is not your native language.

 

[WayneRyan]

Pat,

It's my best language. But I'm trying to learn others (FORTRAN, COBOL),
no use limiting myself.

Wayne

 

[johnzila]

thx
another question....

How to i delete the last record of a table from a FORM?

like i just enter a new record... i just wana delete tat new record?

The default wizard button dun cater to that...
i need something like move to last record and delete?
anyone know the codes?

 

[Pat Hartman]

You need to know the record's unique identifier otherwise there is no way to determine the "last" record. By "last" you really mean most recent so DLast() or Last() will not produce correct results especially in a multi-user environment.