Search results

Ahhh.. yes! I knew it was something simple, thank you! Here's the final code for anyone that may need it: Private Sub NULL_LOG_AfterUpdate() If NULL_LOG = True Then Me.t_QC_sub_log.Form.DataEntry = True ElseIf NULL_LOG = False Then Me.t_QC_sub_log.Form.DataEntry...

Hi... I've searched, but have not quite found what I'm looking for... I have a form "QC_Form" and its subform "QC_Log". I'd like to be able to have the option to set the subform into data entry mode (so all of the current/previous entries are hidden and new ones can be entered), and then turn...

Sure enough, the issue was that is was not an updateable record source. Via your link I discovered this was my issue: It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables. I revised my query join types and everything works now. Thanks Again!

Hi John. Thanks for the quick response... Both the barcode and the check box are on the subform. I tried changing the code after looking at the link you posted to: Me!ShippedOut.Value = -1 and had received the same error code. Any other thoughts? Thanks.

I have a form that's used to ship out barcoded elements. The Main Form is the transaction information (shipping to/date of etc), and the subform is the list of barcoded element(s) to be shipped (barcode #, media details, check box (indicating the item is out-of-house)). In the past I've...

Thanks for the replies... Missinglinq... Yes, I found the problem... the AssetID field I had on my form form was from the Asset form, not from Maintenance.AssetID. Problem solved. Thanks!

Missinglinq, I'm implementing this set-up on my form(s) as well. I'm wondering if this code can be modified... So far you solution works for me, except if I were to open up the "Maintenance" form on it's own and select the "NewRecordButton". When I select the button in this way VB gives me a...

Paul, I justed wanted to say thanks! I too was looking for the solution that TownDawg was looking for. Your solution was the cleanest and easiest I've read so far on this forum. Plus your site help me solve my cascading cbo problem. Thanks again, Matt