I have a table with only 1 record (and it will always have only 1 record.)
I'm looking for a method of updating the record's values by replacing them with the new values from a record in a second table (with many records). The record selected from the second table would be based on a option that the user selects on a form....
Currently, I have a delete and insert set of statements; however, a form which has this table as its record source is visible thru the process (of delete and insert) and I am able to get the form to requery to the new values (it seems to be getting lost during that perioid when the table has no record ?)
I had a thought that rather than delete / insert, I could use an update statement instead (?)
Q. Is there a way to use a wild card so that all of the fields in the record are upddated with values in the second table? (both tables have identical fields.)
Something like: UPDATE tbl1stTable SET * = * where <...>