Search results

lagbolt, I beleive this is a new thread for this one. http://www.access-programmers.co.uk/forums/showthread.php?t=213678 I've tried to help but dont' know how to reference the subform control based on the DoCmd.Openform command. Larry

DoCmd.OpenForm "Frm_Company", , , "CompanyRef = " & Me!ListCompany And "Forms!Frm_Company!SubFrm_Contacts", , , "ContactRef = " & Me.ListCompany.Column(1) The syntax is wrong on this but unfortunatly I don't know how to reference that subform in that command line Maybe try this...

The code I gave you works on my search form. I think it may have somthing to do with the date format you have in the DB. I believe you have DD/MM/YYYY and when you select a date it's format is MM/DD/YYYY

http://msdn.microsoft.com/en-us/library/bb208934(v=office.12).aspx Try this article

Okay, so I'm attaching a mock database for some help here. if you click the Case review button you'll see the main form with a subform. the subform has 3 combo boxes the last two are based on the first combo. They hold values in the table but don't show when going back and forth between...

Where are you building the query? in the Query designer or in VBA?

Could you save it in 2003? I don't have anything higher on my home PC.

Not trying to push you out of the way...just trying to help. :)

Try CBool() it's in the Build portion of the query

Could you clarify where A= null and B="test" comes from? use this to recreate your db...and I'll have a look.

could you post your DB?

Can you do that in a query? Shouldn't it Select a.Id as aMatch, a.*, b.* FROM TableA a RIGHT JOIN TableB b ON a.ID = b.ID WHERE a.Id is not null

so you basically want to reference the subform control via the DoCmd.Open for criteria? Below is a link on referencing: http://access.mvps.org/access/forms/frm0031.htm I would think you would have to do something like this...but I'm not sure. First put the contactId on the...

How about using the after update event? docmd.runsql "INSERT INTO table_name (column1) VALUES (" & me.cmboxvalue1 & ")" me.cmbox.requery

What about changing the view to a continuous form look? (showing all records) you should be able to "scrounch" the view so it looks similar to the datasheet view. then put a button out to the side ("edit") or on the double click event to open the edit form. DoCmd.OpenForm "frmNameHere"...

I just tried the format and that didn't work but the input mask worked find for the text box. What version of Access are you using?

Righ click on the text box and look for "format" in the properties. Does that not do what you want?

Where does the user select the date range from? i think what you want to do is look into the DAO.recordsets This way you form can have a record set that you can search for using a date range then look up the values to populate your text boxes. Then you'll need to create a button that...

Hey Foxtet / Gina, I did a little work on it. I moved the code to the "filter" button. One thing I noticed is that your date format is different from what the date selectors give. I think that may be the issue on why they don't work, other than that it should work. you can enter a...

Hey, So I have a continuous subform that has 3 combobox fields in it. When those fields have a value the .column(1) is entered in an unbound text box. When navigating to a new record I'm getting the error 3075 missing cmb.locationId. What kind of logic do I need for it look at a new...