Ok, so this is my first post - hopefully I'm in the right place.
My DB form is for logging support emails. I have a primary key 1,2,3 etc and also a field where I want a reference to the support i.e. 2019-1-R
The 2019 is the date, 1 is the primary key and R is from a combo box on the form. The date is also on the form.
I have read about a few ways to do this and at the moment I have something similar to this in the control source of the text box;
= "[DateReceived] & "-" & [SupportID] & "-" & [SupportType]
This works as it puts what i want in the text box on the form however I can see that it doesn't populate that result in the table.
Am I going about this the right way. I did read about an update query but I could only get this to work when I updated it for all records i.e. it didn't seem to just automatically update after each record was created.
Hope that all makes sense. Thanks in advance.
My DB form is for logging support emails. I have a primary key 1,2,3 etc and also a field where I want a reference to the support i.e. 2019-1-R
The 2019 is the date, 1 is the primary key and R is from a combo box on the form. The date is also on the form.
I have read about a few ways to do this and at the moment I have something similar to this in the control source of the text box;
= "[DateReceived] & "-" & [SupportID] & "-" & [SupportType]
This works as it puts what i want in the text box on the form however I can see that it doesn't populate that result in the table.
Am I going about this the right way. I did read about an update query but I could only get this to work when I updated it for all records i.e. it didn't seem to just automatically update after each record was created.
Hope that all makes sense. Thanks in advance.