Search results

Ross, Sorry to repost, but I thought it best that your code be posted here. A lot of people follow posts, and when code is posted privately, others are not able to see solutions / outcomes / arguments etc. Code as from Ross: Private Sub Repo_d_Click() stDocName = "Update...

Still no clues - (I am getting dumber and dumber by the minute trying to read your code :( ) There seems to be no events that would fire due to lost focus etc. According to our good friends at Microsoft, this error occurs when a Sub procedure and a form object have the same name. Check that...

:confused: The on-click event fires every time the check box is clicked (in theory anyway) Could you post the full code of the form. Or try adding a Msgbox to the event and comment out the queries temporarily to see if it is actually firing each time - It could be the queries causing an...

Use the query as the recordsource of the form. You can then construct the form as per normal. If you wish to add / edit records via the query (or form based on query) you will have to ensure that the query you have created is an "updateable recordset". Brad.

Which event are you using?

This is caused by your cascading combo restricting the data display. I suspect that you have a criteria statement in the rowsource of your second combo that specifies the value of the first. Making a selection in the first will then requery the second. yeah?? If so, remove the criteria...

'tis Friday morning here, so your tomorrow will be my "Beer O'Clock" time. I am sure some other poor working soul will be happy to help you whilst I am at the Pub. Cheers. Brad.

The code you posted does not give me any clues. The only code functioning on posted list is the "BeforeInsert" code as specified by Pat. This event does not "fire" until the user starts to type in the blank record (but works before a new record is created - thus lets you assign the PK) If you...

Was "just a list", now not "just a list" - Ah, the plot thickens. OK: Your frmCOMPANYDETSUB should be based on a recordsource with the criteria line for the PK (ID) in the following format: [forms]![frmMAININTERFACE]![LISTSUB]![CompanyID] (ensure that the CompanyID and TextBox CompanyID do...

The structure of your OpenForm command is incorrect. Try: docmd.OpenForm "FrmAdoptF",,,"FamilyID = " & Me.LngFamilyID Note: FamilyID should refer to the ID on the form to be opened, amd Me.LngFamilyID should refer to the ID on the current form (the one with the open button on it). HTH Brad.

Hi Ed, Given that your LISTSUB is only a list, have you considered using a list box (rather than continuous subform). This will avoid having to reference between subforms. Your second subform frmCOMPANYDETSUB could be based on a query recordsource with the criteria referencing your new list...

Like a dollar for every time this has been posted :rolleyes: HTH Brad.

After last years season, I thought you would have taken any excuse to change teams!

Post what you have so far. (Maybe Vass will correct it for you.) No, I'm sure someone will be able to correct it if you post the code. Brad

Your from SA, live in QLD and go for the Blues??? :confused: Go figure?? Carn the Dees!

Sunny Queensland - Half your luck! When you used the wizard to create the form, it would have compiled a query as the basis for your form (called the record source). You will have to edit the record source in order to include your extra field. Bring up the properties of your form, and then...

Just Lazy ;)

Andy, Check the help files for the "select case" statement Or search the archives here. Plenty of examples for what you want to achieve. Post back if you still have trouble. Brad.

Here's one for you: Query by form using dynamic query: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45163 Quite a good thread. Includes a link to an MS KB that should get you going. Have Fun ;) Brad

do a search on Dynamic Queries I think that should keep you entertained for a while :) Brad