Your form should be bound to an updatable query (or less desired IMO, a table). If it's not, then that's the first fix. Looks like it is because you no doubt used the form wizard and accepted that Access named your controls with the field names they're bound to. However, you test adding records to a query first when using that as the form recordsource. If you cannot add/edit then you can't use said query as the form recordsource and would have to address that.
You're showing Expr1 in the name control, what is that? If it's an expression in the control's controlsource, you cannot bind such calculated form controls to table/query fields.
does the member id value update automatically?)
Can only do so if the control is bound to a field and the form to a table/query. This happens if any of the following take place (after editing any form fields)
- you close the form
- you navigate to or select another record
- you Save (from the ribbon or Ctrl+S)
- you do so via code
At the moment, no clear idea why you can't pick a date and show it in the textbox. You've set its locked property to true?
Suggest you do not use special characters (save for underscore) or spaces in any object names. I think you'd find much of the following very informative and helpful as you're making typical fundamental mistakes in design ...
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.com...ng-part-i.html
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.com...cation-in.html
Important for success:
Naming conventions - http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837
What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://access.mvps.org/access/general/gen0025.htm
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - http://www.mendipdatasystems.co.uk/m...lds/4594468763
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.