Insert field

[Ken]

I have a table called named tblTemp. One of the fields is named TransDate. What I'd like to do is take the date from a field on a form and insert it into the TransDate field in every record in tblTemp. Any suggestions

Ken

 

[BamaBlacksmith]

An "update" action query will solve your problem..

I have a table called named tblTemp. One of the fields is named

TransDate. What I'd like to do is take the date from a field on a form and
insert it into the TransDate field in every record in tblTemp. Any
suggestions?

 

[John Vinson]

I have a table called named tblTemp. One of the fields is named TransDate. What I'd like to do is take the date from a field on a form and insert it into the TransDate field in every record in tblTemp. Any suggestions?

Ken

An Update query will do this:

UPDATE tblTemp
SET TransDate = [Forms]![NameOfForm]![NameOfField];