Recent content by Pangloss14

Is it possible to store the values from the from as variables in code rather than referencing them from the forms? I've got the same concept as the original poster, I've got a report based on a parameter query (but I need those values for other purposes as well). What I would like to do is...

Hi, Perhaps I'm missing something here... Anyhow, the query I'm using is as follows: SELECT tblTestDetails.Result, tblTestDetails.TestID FROM tblSample INNER JOIN tblTestDetails ON tblSample.SampleID = tblTestDetails.SampleID WHERE (((tblTestDetails.Result)<>0); For each Sample, I have...

Hi, Sorry about the vague title, couldn't think of succinct way to describe this... I have a table (tblSample) with the primary key of SampleID. It is the one side of a one to many relationship with tblDetails (foreign key is SampleID) whose primary key is the combination between SampleID...

Hi, I have a report with an option group that links to a field with values between -2 and 2. Is there any way to make an option group with only two choices, one choice is if the value is 0, and the other choice if it's any other value. It seems like it should be simple enough but I've been...

Hi, I think what you need is Response = acDataErrContinue to suppress the error message. Hope this helps, John

Hi all, I figured it out. Hopefully this will help others. It turns out that the DataEntry flag was the key in this puzzle. I had to add Form.DataEntry = False in the AfterUpdate event of the main form. What I don't understand is why I needed to do this when the form's data entry property...

Hi Pat (and others), I think that either you don't understand the issue that I'm having or I don't understand your solution. All the fields in question are part of the same table so a query doesn't change anything in this case. I'm not trying to populate fields using code, I just need the...

Fofa, OMG, I'm so stupid. I had the query right, I had my tables set up right, I just didn't populate the tables correctly. Anyhow, thanks for your input, it made me think about what I had done. Regards, John

Hi, I'm trying to create a database to keep track of tests. Basically, I want to have a sample on which multiple tests are done, then each of these tests has subtests. When all is said and done, I would like to be able to query by sampleID and find a list of everything pertaining to...

Hi, Table 1: ID (Primary key), a bunch of other stuff. Table 2: ID, Test, Result. Primary key is combination of ID and Test. What I want to do is have a form to input the various test results using option groups for the input. For simplicity, let's assume for now that the...

Hi, Thanks for the input but I'm not quite sure I follow completely. Would you happen to have a sample DB handy? Thanks.

Hello, I'm still stuck. Maybe I'm dumb:confused: , anyone have an idea? Thanks. John

Hi, Beef and DblDogDare, thanks for your input but I think my problem is slightly different. I'm not actually having any trouble getting the combo box itself to update with the new value. My problem is that the combo box in question is used to look up other values. For example, if...

Bumping thread... I hope this isn't bad etiquette, I'm still stumped. Thanks. I actually found that by I can get what I want by requerying the form, but I haven't managed to get this done automatically. I created a button with form.requery to do this. I tried putting the code in several...

Hi, I was wondering if you could post the code that you used for your subform. Also, curious whether your subform was adding any data in addition to the information that triggers the NotInList event. In any case, I can get the data the triggers the NotInList event to show up in the...