New Record Addition Problem and Question/ Query / Form

[Caz]

Hi



I have a question about how to get newly added Records to appear in a search in access.

Basically I have one table with all relevant information needed, etc, and I have the original spreadsheet data inputted to the database. The original data appears fine when a search is done, eg, the user searches for something using a form that then uses a query and ultimately brings up the information that matches. In the queries, I use the same basic criteria- "LIKE "*" & [Forms]![FormName]![FieldName] & "*" ".

My question is, now that I have a form to add a new record to the table so a user can add to it, what would be the best way to get the added record to appear during the search, like the original records? I have used " IS Not Null" at the end of the criteria within the query, but it tends to bring up all the new records no matter what the user searches. Is there a way around this?


Thanks

[CJ_London]

answer depends on how you are viewing your query - if it is a query then close and reopen it. If it is a from then either close and reopen the form or refresh it. If it is a subform, requery it

[Caz]

I have tried running the query with the newly adding information in it, and then viewing the information by searching through a form, which will then bring up a new form that has all the fields of the table to allow the user to see all the information based on the search. If you know what I mean.

[orange]

I'm not following your issue.
Describe the issue in plain English. Then if you have a form, or form/subform, set up please describe it, or show us a jpg.

Normally if you enter a record into a table via a form, after entering that record, if you requery the form, the new record should be available-unless you have some constraint that eliminates it from the result.

If you have records

ABCD
XDERY
PUUYR
and you add a new record QwadRR
then do a current form Requery (which should rebuild your form's recordsource) then

ABCD
XDERY
PUUYR
QwadRR should be available to you.


Show us your table design.
Show us the records in the table,
then show us the query to add a new record,
then show the table data again.