Search results

I have a combo box uses it's after update value to filter a subform. this works fine but my problem is: When the value in my combo box does not have an attached record (yet) the subform returns all records with the first combo box's value. I would like for it to return NO records. My other...

I built an update query that adds two strings of text together with a _ inbetween. eg field1 = Hello Field2 = Jamie after update= Hello_Jamie This works fine but when i attempt to run the code in SQL on an after update instance i can't get it to compile The SQL straight from the working...

Hi, I'm designing a database but it is turning into a bit of a state. :( I Understand that my approach is probably poor but i am fairly new to Access. and realln need some advice/help All other programs i have written have used inputs from list and combo boxes to wirte to a table. This is...

Hi, i have been using the forums for a while now but this is my first post.. there's some very helpfull information on here but i have yet to find an answer to my query by using the search. I'm wondering if it is possible to use an update query to update a single record in a field. I have a...