Search results

Created a work around to overcome the issue. Thanks to everyone for their responses.

Hi Maj. I added the Category to the lookup table after I had created the form. Then I went back to edit the Combo Boxes. When it wasn't behaving as I expected I re-created the first Combo Box which is why it's different to the others. Trying to get it to behave properly before I updated the...

Hey Gasman. That's how I set mine up too and still have this issue.

Hi Bob. Thanks for your response. What's weird is that changing the Bound Column does change what gets stored in the table, but not what is displayed in the Combo Box in the Form. I've attached the database so you can see what's happening. It only contains a couple of records with test data...

Hi guys. Had a look but can't find anything in the forums on this issue. I have a combo box referencing a table via the query builder. There are 7 columns in the lookup table and I want to store the value from column 3. I have set the 'Bound Column' to column 3. When viewing the data in the...

I came across this issue many years ago and yes, was frustrated by the fact that the column header is counted, so had to use the -1 process.

Thanks for all the feedback folks. Recreated the form from scratch and it now works as it should. Must have been some little bug somewhere associated with the previous form. Thanks once again for all your responses.

I probably should have also stated i'm viewing the Form in 'datasheet' view. I wouldn't have thought that should make a difference should it???

Yes i've done that. Even closing and re-opening both Forms and even the entire database doesn't solve the issue. Have started swearing at the screen to see if that helps....

On the checkbox is bound to it's own field in the same table as the other fields. Have tried the method suggested and it's still not working. The form references a linked table. That shouldn't make any difference should it??

I've placed it on both the subform and the mainform.

I'm trying to do the same thing on a subform. I've got a yes/no field called 'Archive' and have filtered the Form to show records where [Archive] is 'false' however all records are still being displayed. Any suggestions or help greatly appreciated. A screen shot is attached.