MS Access：新增查询行时如何将查询名设为字段默认值

Got it, let's tackle this exact problem—you've got your Resistors and Capacitors queries working great for viewing data, but when users add new rows through those queries, the Type field doesn't auto-populate with the matching value (like "Resistors" for the Resistors query). I've dealt with this a bunch in Access, so here are three reliable solutions:

1. Use a Bound Form with a Default Value #

This is the most user-friendly approach, since forms give you full control over input behavior:

• Create a form bound to your Resistors query (repeat this for the Capacitors query later).
• In the form design view, locate the text box or control linked to the Type field.
• Open the Property Sheet (press F4), navigate to the Data tab, and set the Default Value property to "Resistors" (make sure to include the quotes).
• For the Capacitors form, set the default value to "Capacitors" instead.

When users open the form and add a new record, the Type field will automatically fill in with the correct value. Saving the record writes it directly to the Components table, and the new row will show up in the corresponding query right away.

2. Set a Default Value Directly in the Query #

If you prefer letting users work directly in the query's datasheet view, you can set a default value for the Type field in the query design:

• Open your Resistors query in Design View.
• In the design grid, find the Type field row. Look for the Default Value cell in the lower "Field Properties" pane.
• Enter "Resistors" into that cell (quotes included).
• Save the query, then test adding a new row in datasheet view—you'll see the Type field auto-fills with "Resistors".

Repeat this for the Capacitors query, setting the default value to "Capacitors". Just confirm your query is updatable (yours is, since it's a simple SELECT * from a single table with no locks from aggregates or complex joins).

3. Use a Data Macro for Table-Level Safeguards #

If you want to enforce this rule at the table level (to prevent blank or incorrect Type values no matter how a record is added), you can use a table data macro:

• Open the Components table in Design View.
• Go to the Table Tools > Design tab, click Create Data Macro, then select Before Insert.
• In the macro designer, add a SetField action:
  • For Name, select [Type]
  • For Value, you can add logic to validate or set the value (though pairing this with the query default method works best—since the query sets the intended Type, the macro can ensure it's not left blank).

For your specific use case, the first two methods are simpler and more direct. The data macro is a good option if you need extra safeguards against invalid entries.

内容的提问来源于stack exchange，提问作者Dan