Recent content by gbuckton

thanks again for the response pbaldy. I'm a bit confused as to what exactly is 'mycontrol' in this code: [Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null I plan to have a dropdown list or combo box called 'Species'. The first, and default, value would be 'All', and then...

Thanks pbaldy, I have fixed the issue in the Sorting and Grouping setup. What would be the best way to 'filter' my reports so one can select to output info on a specific field, eg. Species = Blue Jay? I'd like to have a dropdown for Species, and, if possible, an additional drop down to...

Hello, I have borrowed code from a DB example on this site to produce a form where you can select a date range to produce a report. It is working fairly well, however, when I select the dates and click "Open Report", I am prompted to Enter Parameter Value for Part Number and Production Date...

thanks I'll give that a shot

Ha! OK yes indeed deleting the Control Source of the combo box fixed the issue and now the Species can be selected... BUT, my understanding (well, assumption!) from the example I followed was that once the item (species) was selected in the drop down, the related Report would automatically pop...

I deleted the form's recordsource but the same issue is occurring. I noticed when I left-click on a Species value in the drop-down list, I get this error message in the bottom of the MS Access window: Control can't be edited; it's bound to unknown field 'SpeciesID'. Does that help clarify?

Hello, I would like to customize my reporting so the user can complete these steps: 1) select a species from a drop-down list 2) generate a report for that species Following the example from this post, I have created the following: 1) a form (ReportSelect_Species) with a drop-down Species...

thanks Missinglinq, that fixed my issue. thanks everyone for your help! G

Back again as I've noticed one other thing. When I open the Form directly from the Database 'Forms' Window, the form opens properly with all data populating the fields. But when I open the form through the Swithboard (set to open form in Add mode) it is not displaying the data in the fields as...

Hi CraigDolphin, I have checked your three possible causes, but they all seem to be fine in my DB. One thing I've noticed is when I open the form initially, all fields are blank, however, when I go into Design mode, and then back to Form mode, the fields are populating properly from the...

Yes that fixed the issue for the main form, but the subform (I also set the DataEntry to 'no') is still not displaying any values even though they are in the table... any suggestions?

arghhh!!! not sure what happened - but now my form is not writing to my table. When I close and re-open the form, it is starting at Record 1 with all fields blank, even though Data was entered previously, and is still in the table. any ideas? thx

thanks everyone, that code worked!

I have the following code so my Combo box displays all of the values in a column from another table (table = Observer): Row Source: SELECT DISTINCT Observer.ObserverID FROM Observer; this works great, however, I'd like my combo box to display 2 columns - the values from 2 different columns of...

thanks I'll give this a shot!