how do i use a form to update a table - exception......

[sbshelp]

the form adds a date. the table is to have only one date and one record. i
want that date to change whenever the input form is used. how?

 

[Ofer]

If I understood your question, and you want to set the date field to the
current date (for example) everytime the form is loaded, then on the OnLoad
event of the form you can add the code

Me.[DateFieldName] = Date()

 

[sbshelp]

ofer - actually i have a form that is "start date" and another that is "end
date". it is for a report on quarter information.
the use puts each in so it can be any date.
it works fine BUT it just adds anoter record and i want only that ONE record
to change. the value. thanks!

If I understood your question, and you want to set the date field to the
current date (for example) everytime the form is loaded, then on the OnLoad
event of the form you can add the code

Me.[DateFieldName] = Date()

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

the form adds a date. the table is to have only one date and one record. i
want that date to change whenever the input form is used. how?

 

[Ofer]

You can set the AllowAdditions property of the form to No, so it will open it
with edit only, and you wont be able to add records

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

ofer - actually i have a form that is "start date" and another that is "end
date". it is for a report on quarter information.
the use puts each in so it can be any date.
it works fine BUT it just adds anoter record and i want only that ONE record
to change. the value. thanks!

If I understood your question, and you want to set the date field to the
current date (for example) everytime the form is loaded, then on the OnLoad
event of the form you can add the code

Me.[DateFieldName] = Date()

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

the form adds a date. the table is to have only one date and one record. i
want that date to change whenever the input form is used. how?

 

[sbshelp]

thanks ofer - also deletions - additions and data entry all set to no!
appreciate it!

You can set the AllowAdditions property of the form to No, so it will open it
with edit only, and you wont be able to add records

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck

ofer - actually i have a form that is "start date" and another that is "end
date". it is for a report on quarter information.
the use puts each in so it can be any date.
it works fine BUT it just adds anoter record and i want only that ONE record
to change. the value. thanks!

If I understood your question, and you want to set the date field to the
current date (for example) everytime the form is loaded, then on the OnLoad
event of the form you can add the code

Me.[DateFieldName] = Date()

--
Please respond to the group if your question been answered or not, so other
can refer to it.
Thank you and Good luck



:

the form adds a date. the table is to have only one date and one record. i
want that date to change whenever the input form is used. how?

 

[John Vinson]

ofer - actually i have a form that is "start date" and another that is "end
date". it is for a report on quarter information.
the use puts each in so it can be any date.
it works fine BUT it just adds anoter record and i want only that ONE record
to change. the value. thanks!

Any form - or control - which you're using *just* as criteria for a
query, as in this case, must be Unbound. Simply use a Form with no
recordsource, or textboxes with no Control Source.

John W. Vinson[MVP]