Using a form to do 2 separate tasks

[travelmedic]

I have a form that I can input info into, and have it save to a table.



I wanted to know if I could also have the same form pull up the info and modify it. Like if I input employee info into the form, I would like to be able to go back to the same form, search for an employee, and update any info I need too.

Right now the form shows 1 or 1 record, but the table associated with the form has all the records listed.

[Micron]

Very possible.
Is it a single form (only shows one record) but you can navigate to other records, or is it some other type?
Are you opening it in a Data Entry mode (can only see one new record and no prior ones)?
Does the form recordsource return more than one record (is that a query?) or did you bind it (link) to a table instead?

Might be quicker if you just copied the db, compacted then zipped it and post the copy here.

[travelmedic]

It's a single form that opens up to a new record and you can't see any other prior records. You can't navigate to other forms, it only shows 1 of 1 record. I guess it's bound to a table.

Very possible.
Is it a single form (only shows one record) but you can navigate to other records, or is it some other type?
Are you opening it in a Data Entry mode (can only see one new record and no prior ones)?
Does the form recordsource return more than one record (is that a query?) or did you bind it (link) to a table instead?

Might be quicker if you just copied the db, compacted then zipped it and post the copy here.

[Micron]

You must have its Data Entry property set to yes. If you want to open it that way sometimes but not always, then something (e.g. button click, combo selection, option button, etc.) needs to tell your code Open Event what form properties you want to set at that time. This is the way to do it - not make multiple identical forms to different things.

If you want records for employee and there are not too many of them, a combo (only allows 1 choice) or listbox (can allow several choices) could be used to retrieve records for the one(s) chosen. Maybe that would go in the form header - maybe that choice should be made on some sort of selection form that tells this form how to open and what to load. Many ways to do this. If you don't want to post a db, perhaps Google something like "ms access how to open a form several ways" or something similar. Here's but one
https://stackoverflow.com/questions/...-using-buttons

Note that you need to affect form properties that will either open to only add records, or view them instead. Some code samples you'll find only show how to filter records, and that isn't good enough for this.

[Welshgasman]

I have a form that I can input info into, and have it save to a table.

I wanted to know if I could also have the same form pull up the info and modify it. Like if I input employee info into the form, I would like to be able to go back to the same form, search for an employee, and update any info I need too.

Right now the form shows 1 or 1 record, but the table associated with the form has all the records listed.

That is how I have always used my forms?

[travelmedic]

The data entry property is set to no. Right now I don't have a lot of employees entered, but I will have over 200 employees entered. I can't get the db to compact enough to fit the file size for this forum

You must have its Data Entry property set to yes. If you want to open it that way sometimes but not always, then something (e.g. button click, combo selection, option button, etc.) needs to tell your code Open Event what form properties you want to set at that time. This is the way to do it - not make multiple identical forms to different things.

If you want records for employee and there are not too many of them, a combo (only allows 1 choice) or listbox (can allow several choices) could be used to retrieve records for the one(s) chosen. Maybe that would go in the form header - maybe that choice should be made on some sort of selection form that tells this form how to open and what to load. Many ways to do this. If you don't want to post a db, perhaps Google something like "ms access how to open a form several ways" or something similar. Here's but one
https://stackoverflow.com/questions/...-using-buttons

Note that you need to affect form properties that will either open to only add records, or view them instead. Some code samples you'll find only show how to filter records, and that isn't good enough for this.

[travelmedic]

How? because I've been trying and it's not working

That is how I have always used my forms?

[Micron]

I can't get the db to compact enough to fit the file size for this forum

Did you zip the file first?

Might be quicker if you just copied the db, compacted then zipped it and post the copy here

[travelmedic]

I deleted a bunch of data for the copy in order for the file to zip to a much smaller file size

Did you zip the file first?

[Micron]

I've reviewed all your posts thinking "why don't I even know which form to look at let alone exactly what to do with it"? thinking it's just me.
As much as I like to help everyone, please don't hold back information. If we (no, not just me) have to extract info like a dentist pulls teeth, it becomes easier to just move on.
Have lost valuable time now as I'll soon be out for the night.

[travelmedic]

Sorry for wasting your time then

[Welshgasman]

How? because I've been trying and it's not working

Generally I pass in the criteria for the record(s) I want. I also pass in the same as OpenArgs(), so if no such records exist yet, then I have a new record and can set the values from the OpenArgs, if going from one form to another.
Or just press the New record button in the navigation buttons if just using a simple form.

[davegri]

OP removed the original submitted DB. I got it before that, made mods and uploaded the rev here. Since OP removed original DB, I feel that I should remove my modified version also. And so it goes...