Not gonna work, I want to put a default value, not an actual value, cos otherwise the record will be added to the database, which I don't want to.
I wrote some VB and in the default value box, called this function. seems to work.
This is what I did, I created this function in a module, and in the defaultvalue prop in Access, I called this function ( = default_jaar() )
Public Function default_jaar() As Integer
If Month(Date) > 4 Then
default_jaar = DLookup("cohort_id", "TBL_cohorten", "startjaar =" & Year(Date))
default_jaar = DLookup("cohort_id", "TBL_cohorten", "startjaar =" & Year(Date) - 1)
The difference in your approach is that when I follow your code, I actually put a value in the combobox. If I want to cancel the add new record, I already have created a new record (I work with pop-up forms). So when I folow your code, a new id is given to the record, this is something I don't want, hence this solution.
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Hi I'm having a problem implementing a mini shopping cart drop down in the header to show the user all the products they have in their shopping cart. It seems the only solution for this is Ajax, and I've looked all over and can't find anything that I could possibly ...