Recent content by Reichel

I had a problem in the past with requery or refresh when the focus is on another form than what needs updating ( in this case the pop up) you can try adding a empty control on main form( call it Z for example), make your pop-up move focus to Z on close. Set Z to requery once it gets focus...

Hello, I have a database that is split to a frontend and a backend, the front end was distributed to users. I am wondering if there is a way to lock data editing in the tables in the back end so it stops the end users from being able to edit the data but still be able to view it. Some...

The problem was that one of the link child fields was a calculated field (IIf([Status]="Remove","Remove",IIf([Status]="Incumbent","Inc",IIf([Status]="Suggest","Suggest","Keep")))) which doesn't calculate until you start typing into the new record, hence the error. I deleted the calculated...

the error pops up once you start typing in a new record. this is the full text of the error msg: You can't assign a value to this object. *The object may be a control on a read-only form. *The object may be on a form that is open in Design View *The value may be too large for this field...

Unfortunately this does not solve my problem, because I need the user to be able to add employees to the "employees on plan" table from within the form. I dont think the multiple subform containers with one source subform is the problem, I deleted all of them and kept one only, but I still got...

I am having an issue with a subform where the first time I click to add a new record I get this error "You Can't Assign Value to This Object". The error doesn't actually cause any problems, and if I click through it, the records adds with no problem. My database has three tables, -full...