Search results for query: *

I have a main form which is 1 to many subform based on a field customer_ID each of the two tables has a field called customer_issue the main form has a combo box which currently fills in customer_issue for the 1 record. How can I make the event to on update populate the one customer_issue...

Thanks Aceman, So I tested out your code and it only seems to work if I make a selection in my combo box and then delete it. After deleting my selection if i try to move one or close the window it gives me the error. If i never make a selection and the combo box remains blank i can still move...

Could you provide a little more info on the SetFocus method? My knowledge of VBA is minimal at best.

I have two tables and one form My form has a combobox "customer name" which pulls its info from table 2 named "customers" when selecting the customer name in the combo it updates the field customer in table one. How can I make my " customer name" combo box a required field before closing the...

Hmm there has to be more to it than that. I appreciate the help but i still cant get anything to work. I have tried by looking at examples of code but none of it works correctly.

I do not know a thing about VBA but i need to expand my conditional formatting options to more than three options I simply need to change the color of the text in a record in a form based upon a values in another field ex. if [Value]>100 make [Customer_Name] Font Red if [Value]<100 and...

I just realized this post is probably in the wrong forum and would probably be best suited in Microsoft: Access Tables and Relationships Forum. Sorry for the mis post, as I did not initially see the other forums as options from the main page. Thanks again for all the help.[thumbsup2]

UPDATE NameOfYourTable SET NameOfStateField = Right(NameCityfield,2) WHERE NameCityfield Like '*, ??' JACKPOT! Thank you greatly!

^ Good point haha When I paste the code in and attempt to run it an input box appears asking me to input a value for the [State]field. What ever I put in there populates every record with that input value.

:( still doesn't seem to work. What am i doing wrong?

Would I paste that into the SQL view of an update query?

I'm an access newb and need some help. I did some searching but couldn't find anything. This should be an easy one I have just a simple table [City_State] [State] Field [City_state] has information such as Philadelphia, PA Boston, MA Houston, TX Etc. Field [State] is blank how can calculate/...