Recent content by CJ_London

Think you have to clearly define the overall objective. Is it to reduce waste or reduce stock? Is it to be considered on an order by order basis or by looking at longer term usage to determine common sizes and multiples thereof?

Assuming you have defined the relationship then the FK field has to have a matching parent, or is set to null - which is not the same as a zls - your description does not say, only that you do not allow zero length

If you used a public function rather than a sub, per post #3 change Public Sub CloseForm(frm As Access.Form) To Public Function CloseForm(frm As Access.Form) Then you don’t even need to have a form module for the close event. Just put =CloseForm([FORM]) against the close event on the...

suggest put some msgbox’s to display variable values so you can check the accde ODB does not seem appear to have been declared or populated do you have option explicit at the top of every module?

if you remove all the brackets and replace just around criteria 2 (the OR) I would expect it to look like this SELECT [App Data].[Regi No], [App Data].[Farmer Name], [App Data].Area, [App Data].[Sent To BRD], [App Data].Status, [App Data].[Physical File At] FROM [App Data] WHERE [App...

In that case, implies you don’t have any data to fit the criteria

Have you tried using the query builder - looks like your brackets may be incorrectly paired. or remove all the brackets and just replace them around the second requirement

the nz function only works with null, not 0. Your union query uses 0 so discard the null approach it doesn't matter - your criteria would be tblShowDogs.SectionID=IIf([forms]![frmMain]![cboJudgeSlipsSect]>0,[forms]![frmMain]![cboJudgeSlipsSect],tblShowDogs.SectionID) So if...

Either add one in or use a union query as you mentioned in your first post

You now have 3 options to try

another alternative if the combo 'All' value is null WHERE YourField = nz([forms]![frmMain]![cboWorkSlips],YourField)

Describing what you have is vague- show us. What is the sql to the query that references your combo and what is the sql to your combo?

other considerations - are the fields being linked on and sorted indexed? I doubt it - the first query wont run until the second query calls it

not sure where you are getting your idea of a discoonected recordset - see this link for an example https://www.devguru.com/content/features/tutorials/DisconnectedRecordsets/tutDisconnRS.html assuming you have a linked table to your azure BE then the connection string is simply currentdb.connection

You are talking about a single recordset, not the whole app. Ado won’t work for reports and for forms, the default filtering and sorting won’t work. But for a single recordset being used in vba it is fine