N
NoClue
I get the following error when adding a new record to the underlying
recordset of my form:
data added database won't displayed form because doesn't satisfy
criteria underlying record source.
The reason is because i am selecting the record set based on a specific
ID, which is an autonumber in my sqlserver database. When i create a
new record the error above appears because the new record has a new ID
which does not fit the original recordset source.
Does anyone know away around this?
e.g. modifying the recordset source dynamically
Thanks in advance.
recordset of my form:
data added database won't displayed form because doesn't satisfy
criteria underlying record source.
The reason is because i am selecting the record set based on a specific
ID, which is an autonumber in my sqlserver database. When i create a
new record the error above appears because the new record has a new ID
which does not fit the original recordset source.
Does anyone know away around this?
e.g. modifying the recordset source dynamically
Thanks in advance.