Copy form data in to a table

[bibbyd01]

Hi all

I have a form that updates comment details. It has two text boxes, auto filled when the form is loaded with the date and time. As these aren't linked to table in the form, when the record saves, it doesn't update the table.

How do I do this? I assume there's something I need to enter in to the beforeupdate properties field? The table is called order, and the text boxes are txt_time and txt_date.

 

[John Big Booty]

Why not simply bind them to the underlying table

 

[bibbyd01]

Hi

This is because I wanted the form to be an update comment form, whereby no previous records are displayed. Also, the form it opens from is from a continuous form so it had to be able to update the comments on just one order, without having to enter the order number details. I found that when I bound the fields to the table/query, it created the line in the table, which, if the user created by accident, would have to be manually removed.

Also, I have some default fields that are populated on the form, which I didn't want to be default fields on the table.

I accept I may be going using the wrong kind of logic here!

I have tried to create a query that extracts the data from the form, then run an apend query to transfer the data to the table, but I just couldn't get this to work.

 

[bibbyd01]

I have found a way of copying the data now using VBA code to do this, check all fields are completed and close the form when complete.