Search results

O.k. found the problem after searching the forum a little longer. I had to change the mask to 000\ 0\ 00\ 00;0; in the table and the unbound text box!

Thanks, I confirmed my code appears to be pretty much o.k. now....BUT I think the problem is that the search is taking the input from the textbox without keeping the input mask when it searches the table. The data is stored in the table with an input mask of 000\ 0\ 00\ 00;; This same mask is...

Hi, I have a simple form with one record displayed with just a couple fields. I have an unbound textbox and command button to use as a search field to find a certain record. The problem is that I'm searching on the "TN" field which is stored in the table with a mask "000 0 00 00" which causes...

Anyone have an idea?

I have attached the database. There are only the 3 relevant tables, 1 query, and form, subform. You can see what I mean by opening the form and use the combobox on the subform. I really appreciate all the help! Thanks

Does anybody else have any ideas?

When I remove the UserGroupID from the control source of the combobox, the query no longer works to show current group membership record. I want each current group membership to be listed in datasheet view(this works), with the combo box on the UserGroupID field which will show the three...

Hello there! First time posting, long time lurker. But I've gotten too frustrated to continue. I have started a test db with just the bare minimum to try to narrow down my problem and it still happens: 3 tables (many to many) Tbl_Groups GroupID (PK autonumber) GroupName GroupType...