Search (quiery?) edit and save record form

[streub]

I am attempting to develop a user form that will allow me to enter the value of a textbox (after update?)to find a specific record. The select data from that record would populate other empty or blank textboxes on the form.

There will be two textboxes that I must enter additional data for that record then save all the form data to a new table.

I have tried using several examples and techniques, bound and unbound scenarios and not having any success.



Advise, in layman's terms, will be appreciated.

[June7]

If you don't want to use the intrinsic search tools and need to customize, review http://allenbrowne.com/ser-62.html

Why do you need to save to another table? If you want to do audit tracking, review http://allenbrowne.com/AppAudit.html

Not sure what you mean by: "The select data from that record would populate other empty or blank textboxes on the form."

What does 'not having any success' mean - error message, wrong results, nothing happens? Exactly what have you tried?

[Missinglinq]

...Why do you need to save to another table...

Even more importantly, I think, is why...

...I must...save all the form data to a new table...

Do you mean a different Table? Or do you actually mean to a new Table each time you do this?

Linq ;0)>

[streub]

Damn! I did not explain myself thoroughly.

The data table I want to search contains all my outlet inventory records.

I will be using a form with several textboxes representing the fields needed to self populate after the record is found.

I want to use the arrival number, the primary key, as the value to search the outlet inventory table for that record. I want to use a textbox as the search control (after update) rather than a combo box because there are far too many records.

There will be two blank textboxes, one assigned for the store number that sold the item and one for the date the item was sold. The user will enter that data. The record will be saved to a table "Sold Inventory" and deleted from the "outlet inventory" table using a control button. I am using two tables to separate sold items from available items.

[June7]

Still don't understand the requirement to 'move' record as opposed to just changing a field value. Apply filter criteria to exclude/include records. Exactly what is this an inventory of?

Here's another Allen Browne article to review http://allenbrowne.com/AppInventory.html.

[streub]

I want two tables because I am not comfortable having sold items combined with on hand merchandise.

This is an inventory of mattresses.

Thank you

[June7]

Well, just making life harder for yourself. I understand learning something new can involve some discomfort but if you adjust you will be much better off in the long run. You will eventually look back and wonder 'What was I so afraid of!'

However, if you must, there are several ways to accomplish. Regardless of approach, two actions must be executed. First is to copy data and second is to delete the original record.

Your inventory is such that each individual mattress has its own record? How many fields are involved?

Does record that must be 'moved' have any dependent records in other tables? In other words, is the mattress record ID primary key saved as a foreign key in other table(s)?

[streub]

I am willing to utilize only one table. I know I can query or filter to obtain the information I need but it will take practice.

Your recommended sequence of copying data to a new table and deleting from another is what I had in mind but that is now moot since I will use only one table.

Each mattress has its own record with a total of 10 fields.

Attachment 31809

[June7]

Then there is no longer an issue to resolve?

[streub]

The form is the issue.

I have tried unbound and bound fields and forms with no success. I have researched the web and attempted to adapt some of the examples. I am sure it is something basic I am missing but I don't know what it is.

Should the form be bound or unbound? What about the controls on the form, unbound or bound?

[June7]

I have only ever used bound forms and controls for data entry/edit. Did you review the first Allen Browne link I referenced?

[streub]

His stuff is way over my head. I downloaded his example and will study it further.

[June7]

What, exactly, is the difficulty you encounter in form design? If you want to provide db for analysis, follow instructions at bottom of my post.

[streub]

I found and example online that accomplishes what I need. It took a while for me to understand but it works.

Many thanks.