Search results for query: *

Thanks all for your input. BNPMike's suggestion for declaring two unique indexes worked for my purposes. I do also have a key (ResourceID). I am not sure if this all follows Codd's law, but as Darrylles says, my manager's main concern is getting it done now. Luckily it's a small app which we...

Hi, I have a table with the following fields: ResourceID ResourceName DateTime InstructorID LocationID Misc I have 2 different combinations that need to be unique: DateTime & InstructorID, and DateTime & LocationID. I was going to make a combo key of DateTime, InstructorID, and LocationID...

I finally solved the first problem. The combo was updating fine, but I couldn't see it. I had 2 columns set up in the combo, the first of which was 0" wide. However, I have another problem. I would like the combo to continue updating based on a query, but also to show a blank combo every...

Thanks hennep, but the requery did not seem to help. I will try to explain exactly what I am trying to do so there may be a different approach I could take in my form structure, etc. to reach the same result. I have a table Table1, from which various information is displayed on the form. Each...

Now I am not getting prompted for Me.Text0. However, this is still giving me a blank list. I am wondering if it is a syntax thing for Table2.SysID. When I tried to debug, I add Table2.SysID as a watch and it only says &quot;<Expression not defined in context>&quot; and the type is empty. In this...

Thanks Omega, but I still could not get it to work. I am still running the query from the combo box RowSource. The query now reads: SELECT Table2.Description FROM Table2 WHERE Table2.SysID = Me!Text0; Text0 is a text box whose ControlSource is IDCode. Now when I click on the new combo box, I...

I am trying to use a combo box to show a list of values from a table where the SysID is the same as the IDCode of a different table (of the record currently being displayed). What is the best way to do this? I tried using the following query: SELECT Table2.Description FROM Table2 WHERE...