I have a really simple set-up:
1) Continuous form based on a query
2) The query is based on one table
The table fields include a date, numerical values (= combo box on the form) and short text.
The continuous form has a command button which replicates (or more accurately should replicate) the relevant record when clicked. The problem is that when the command button is clicked two fields in the record (the date and a numerical value) are not replicated but the rest of the fields are (I have checked this in the table).
I tried creating the button as an embedded macro using both the command button wizard and also in VBA code but the incomplete replication is the same, so I guess it is unlikely to be an issue with the code. I also compared the table and form field properties between replicating and non-replicating fields, but can see no difference.
I am sure I must be overlooking something really basic, and it is driving me nuts ! Does anyone have any ideas as to how to solve this problem ? Thank you in advance for any thoughts.