Enter Parameter Value Popup

Question

Hello All,

I'm running a 2019 Access DB that was built by one of my predecessors. We recently changed the verbiage for Customer Requests from CRQ (Change ReQuest) to RITM (Requested ITeM).

I went to the various fields in designview and changed them over from CRQ to RITM, I also went into the VBS and changed all instances of CRQ to RITM (via Cntrl + F, then Replace feature).

The DB still works fine (Macros, opening forms, etc.) so I haven't broken anything far as I can tell, however I now get a Enter Parameter popup that says:

qryAssetRITMs.CRQ_No

Edit: I get this popup whenever I open a form called Asset Details (or "frmAssets_Editable") on any of my Assets in the DB.

skimming through my various tables, queries, and Cntrl +F in VBS isn't finding this elusive .CRQ_No

I'd like to post some screen shots but can't put that network's stuff on the internet due to company policy.

Any thoughts on what this is/where I can find it?

Answer 1

Thanks, but what happens if you double-click this query in the navigation pane? Does it open normally or do you get a parameter prompt?

Answer 2

qryAssetRITMs has the following (DesignView):

Two tables:

• tblAssets (relating 2 items, Barcode and Serial)

to

• tblAllAssetChanges (NewBarcode and NewSerialNo)

[Edit] - tblAllAssetChanges has the RITM_No (and other "_No" fields in there). Only two relations are drawn (as listed above)

Beneath that (hopefully this formats somewhat normally):

Field:	Hostname	ShareName	Barcode	Serial	INC_No	REQ_No	RITM_No	TAS_No
Table:	tblAssets	tblAssets	tblAssets	tblAssets	tblAllAssetChanges	tblAllAssetChanges	tblAllAssetChanges	tblAllAssetChanges
Sort:
Show	checkbox checked	checked	checked	checked	checked	checked	checked	checked
Criteria
Or

Property Sheet:

Description:

Default View: Datasheet

Output All Fields: No

Top Values: All

Unique Values: Yes

Unique Records: No

Source Database: (current)

Source Connect Str:

Record Locks: No Locks

Recordset Type: Dynaset

ODBC Timeout: 60

Filter:

Order By:

Max Records:

Orientation: Left-to-Right

Subdatasheet Name:

Link Child Fields:

Link Master Fields:

Subdatasheet Height: 0"

Subdatasheet Expanded: No

Filter On Load: No

Order by On Load: Yes

The Property Sheet when selecting RITM_No is all blank in General Tab, Lookup Tab only has

Display Control: Text Box

A lot to parse through and I know Screen Shots would be significantly easier, so thank you for helping to troubleshoot this

Answer 3

Thanks!

What happens if you open qryAssetRITMs by itself?

Answer 4

I do not.

I see the following on the Property Sheet:

Record Source: tblAssets

Recordset Type: Dynaset

Fetch Defaults: Yes

Filter: AssetID = 100

Filter On Load: No

Order By:

Order By On Load: Yes

Wait for Post Processing: No

Allow Additions: Yes

Allow Deletions: Yes

Allow Edits: Yes

Allow Filters: Yes

Record Locks: No Locks

Answer 5

If qryAssetRITMs does not contain a field named CRQ_No, open the form frmAssets_Editable in design view. In the Data tab of the Property sheet, do you see CQR_No in the Filter or Order By property?