Want a query to filter by one of 2 parameters

[crobaseball]

I have a couple of different scenarios where I want to change the prices of in our price database. The way in which the database is set up, we have different suppliers, who in turn have different lines of products. I need to have the functionality where the person managing the db can change by supplier OR change by product line. e.g. - Company A increases across the board, whereas Company B might increase prices on a certain product line by 1% and a different product line by 1.5%. I can certainly write multiple queries to handle all of the possible scenarios, but I've got to think there's a cleaner way of doing this. Is there a way where I can use parameters from a form to determine which filter to select in a query? i.e., if they use the "supplier" part of the form to update prices, the query is used, but the only filter applied is for the "supplier", whereas if they use the "product line" part of the form, the SAME query is utilized, but the "product line" filter is applied.

[June7]

I would use VBA to construct the UPDATE sql then run the sql in VBA:

Dim strSQL As String
'code to build string and set the variable
CurrentDb.Execute strSQL

[crobaseball]

So I haven't done much with programming in SWL. I take it that Update will allow me to create a new record?

[June7]

UPDATE only modifies existing records.

INSERT creates a new record.