Search results

hmmmmm......weird I'm not quite sure what happened (or what changed), but it is now working properly. The form has recognized the new clients and the recordset has been updated from 20 to 35.

I have a database form with a tab control, combo boxes, and subforms. The main form has a combo box with a list of clients. When I first created the form, there were only 20 clients. I recently added 15 more to the client table (by hand - not through the form), but the form has not updated...

Try this... If your sub form is on the main form, then try this for the second combo box query. SELECT [Stations].[Line],[Stations].[Department] FROM Stations WHERE [Stations].[Department] = [Forms]![Employee Training Main]![Training Records Sub Form]![Job] GROUP BY [Stations].[Line] ORDER BY...

Still need help... Anyone have any ideas?

I'm having a similar issue with refreshing my combo box... I have a form with several subforms and combo boxes. One of my combo boxes has a list of tests populated from a query. When the user adds and/or deletes a test in my subform, I want the tests combo box to refresh with the change...

Well, I figured it out :D For the AfterUpdate method for Level, I put Forms!Form![Tests_Clients_PerfLabels_new Subform]!TestID.Value = Forms![Form]!TestsCombo.Value. This thread helped me out http://www.access-programmers.co.uk/forums/showthread.php?t=86929&highlight=table+update

You're awesome!! Thanks :D I like how you used a qry for the subform. The next thing I want to do is have it so that the user no longer sees ClientID and Test in the subform (set Visible to 'No'). So the user should be able to select a Level (after already selecting client/test) and the...

Hi, I have attached a small version of my database/form. I am trying to display only those records in a subform based on the values selected from two combo boxes. So when the user selects a client from the 1st combo box, the 2nd combo box is populated with the tests that pertain to the client...

Thanks guys! I went with RichB's idea...very helpful, thanks :)

Thanks Tim!! :)

And my question would be, why not? Is it impossible to do in Access? Otherwise, I can just run an update query to fill in this field or have a query to get whatever information I'm needing...

Thanks for the quick response. Yes, the control source is pointing to a field on the table. I have a list box on the form that is Multi-Select - Extended pointing to a field on the table that is Data Type - Text and a List Box with Row Source Type - Field List. The list box on the form is the...

Thanks for the quick response. I actually have that part already. I'm trying to figure out how to put the new string (i.e. fullname) into a field in a table. I'm taking these two strings from two different tabels and placing them into another table as one. Since the control source is the...

Hi, I am trying to take text from two different text boxes on a form and place into another text box on the form. I want it to also update the table with this new text. Example: fname, lname, fullname are text boxes on a form. when user enters fname and lname, I want the two strings/text to...

Hi, This is my first posting on this forum, and I would greatly appreciate any help with this issue... I have a form that is used for entering information into tables. I would like to be able to select multiple options from a list on a form and have it saved into a table. Any ideas? Is this...