Set bound field to blank

[infact]

Hi. One of the fields that I am pulling into a form from a table has a value that changes daily. I need to be able to enter a new value each day for that field. How do I set up that field on the form to be able to enter a different value each time. I created a text box and bound it to the table and still run into the same issue where I cannot enter a new value into it.
Thanks.

 

[AlexMidd]

Not sure I understand what is haeppening. If you have a form with an underlying query and an editable text box on that form bound to a field, then you should be able to enter a new value and have that field update with the new value.

Can you explain what is happening when you try to enter the new value and whether you have the form attached to a query table that contains the appropriate field.


Have fun! )

Alex Middleton

 

[infact]

To Alexmidd -Thanks for replying. I am pulling information off the database for a specified date using a query. The form is based on the query. When I tried to enter a change in this field (quantity) on the form, I can't enter anything. I created a text box, then bound it to this field. When I run the form, the quantity from the table is in there, and when I try to enter a new value I can't. I don't want to use a combo box because this is supposed to just be data entry that a user can input a new quantity each time. Basically, can't you edit any field on the form whether it's a text box, combo box, or the field as you pulled it off of the table?

 

[TheAceMan1]

how are ya infact . . .

Be sure the [blue]RecordSource[/blue] of the form includes the [blue]primarykey[/blue] of the table . . . if fact, postback the [blue]RecordSource[/blue]!

See Ya! . . . . . .

 

[AlexMidd]

Yes, you should be able to. The only reasons I can think of are that:

a) the text box is set to Enabled: False and Locked: True

OR

b) the query that the form is connected to is not editable.

Have fun! )

Alex Middleton

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[infact]

Aceman1 - The recordsource is the query that the form is based on. I did not include the primary key when pulling records off of the database with the query. Is this whay you mean?

 

[infact]

Alexmidd - I just checked the query and it is not editable.
Thanks.

 

[infact]

Aceman1 - The recordsource of the form is a query I set up made up of two tables :
Table 1 Table 2
id (access set this a key) id (access set this up)
machine getmach
serial getser
date getdt

Table 1 has a few more fields, but just to be brief I'm showing the main ones. I set up a relationship between Table1 and Table2, joining them by machine/getmach. I created a query, using machine, serial, date, getser, getdt. I did an autoform, and when I try to edit any of the fields, I get the message "This recordset is not updateable". I can't seem to find what I'm doing wrong.

 

[PHV]

Have you read the link I gave you ?
Include the Primary Key of Table2 in your query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886