Simple form Question on Unbound textbox

[qitcryn]

thread702-1309854

The previous tread help in adding a rom of unboind textboxes.. but now i need to know what coding to use on the unbound text boxes, so the data can be populated ??

So i have in the form called customers subform from a table called cutomers the folowing fields:
-Combo box
-Calldate
-Paymentamount
-Paymentdate
-Followupdate
-Notes

And i need the unbound textboxes to enter data then update the recordset with the info.

Thanks,
Ivan

 

[TheAceMan1]

How are ya qitcryn . . .

What have you tried? ... What to do is spelled out in the thread!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[qitcryn]

Hello TheAceman1,

I haven't tried anything, becuase i don't know how or where to begin. I don't know how to (or remember how to) have data entered in an unbound textbox, and populate to the field in a form. I've searched online, and i'm just rattled...So i put the project away for a few hours hoping it will come back to me...im getting frustrated.

Thanks,
Ivan

 

[randy700]

Where do you expect to get the data FROM?

Randy

 

[qitcryn]

the data is contained in the table.. so heres what i have:

Table: Customers
Field: Cust #
Field: Status (combo) from status table
Field: Calldate
Field: Paymentamount
Field: Paymentdate
Field: Followupdate
Field: Notes

This table is in a subform named; Customersubform.

According to others, i should place unbound textboxes in the header of the subform, on which i can enter the data...and that will update the table.

The goal is to have the subform show me the last populated record first. then once i enter data, refresh and show the new record.

The problem i've encountered is that the subform will load on the last updated record, and the new data i enter is overwriting it. and Not a blank record.

So the end goal is to open the form and see the list of calls showing blank record first then newiest to oldest populated records.

 

[randy700]

Why not use bound fields.
Your records will all be available and you can
simply add a new record.

However, I'd create a query, rather than base the
form on the table.



Randy

 

[TheAceMan1]

[blue] ... but now i need to know what coding to use on the unbound text boxes, so the data can be populated ??[/blue]

As far as the context you've provided is concerned, I'm not sure what you mean by populated. The thread simply involves moving the [blue]new record line[/blue] at the bottom [blue]to the top[/blue]. Data entry here (new record) is typically by the user!

Are you asking for the code to save the new record, update the view and clear the new record line?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[qitcryn]

" Are you asking for the code to save the new record, update the view and clear the new record line? "

The first...I want to enter data in the unbound text boxes and have data save to record set in the subform.

 

[TheAceMan1]

qitcryn . . .

An Append query followed by a requery of the form should do that!.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]