help with autofill value

[ShannonMarie]

I have a master table named Employees. I have a table for Employee Family Information. I want the autonumber for EmpID to auto fill the value of the EmpID field in the Employee Family Information form? When I wrote the Select Query it shows only AutoNumber. (As a list box) I would like for the current employee id number to show in the employee id box. Or am I maybe confused in the logic behind what I am trying to do. Any input would be appreciated. Thanking you for you time in advanced.

 

[mderby]

Hope it work

Hi ,

I've encounter this problem before.
The culprit behind this may lies in the Employee Info Form's
DATA ENTRY properties.

Change the DATA ENTRY property to "No" in the current form
properties.

The explanation behind this is if DATA ENTRY is "Yes" then the form will be in Add mode upon loading.

Hope it works for you.

mderby

 

[ShannonMarie]

Thanks!

I deleted the form and set all field through the record source instead of using a query. It filled everything fine. The drop down arrow is there, however, that is not such a bad idea after thinking about it. The employee id may be selected instead of assigned in this form. I had not thought about the Data Entry property though. I will keep that in mind. Again, thanks for helping!

 

[jodilees]

I have found this discussion very useful

The one problem I am having is I want the form to do a lookup. I have it doing this and I want to enter say the client number into the client ID field and then the details for that client will be displayed.

I have changed the data properties for the fields I want it to look up. But when I do this, I type in a client number and it is changing the number for that particular client.

If I change the properties of this field to no it won't let me enter into the client details.

I am sure it is a simple step I am missing but am going in circles trying to find it.

Please let me know

Regards

Jodi

 

[soundsfishy]

Hi jodilees,

Why don u use dropdown box to find the client ID to find the clients details. Use the wizard. There are other ways to find client but using the wizard is a good starting point.

feel free to PM me if you need futher help. I'll see what I can do

 

[jodilees]

From the message above I don't think that really helps me in this instance.

I have a Form with the following

ClientID
Company Name
Contact Person
Phone Number

I want the users of the Dbase to have a printed list of all of the ClientID's and Company names. From here when searching for or entering a new record in they will type in the client ID and it will autofill the rest of the information.

On the same form I intend to put in a section of the form that contains all the information on the Repairer much the same as above. The same will apply with this information.

I then intend to have a section below this that is the information relative to this particular repair.

I don't have the drop down option at this point and given that we will probably get up to 500 clients in this particular register I don't think a dropdown is the way to go.

Please let me know if you can think of another way.

Regards

Jodi

 

[soundsfishy]

I dont know if this is any help.

I kinda get the jist of what u r trying to do. Another way of searching for a client would be to create a macro in this way. A lilittle pop box will appeat asking the user to enter a the ID number :

GotoControl (the name of Control eg clientID
findrecord (edit these field to suit)
runCommand (in the command , place Find.)

Then on a cmd button add the macro on the On_click.

 

[jodilees]

Not sure if that is the best way cause as I mentioned before it is sort of working.

To explain in Detail.

I currently have two tables - one a list of Clients and the other a list of Repairers. I am sorting them using a unique number C0001 etc for clients and R0001 etc for repairers (we contract some of our repairs out to other businesses)

When a client brings equipment into our office for repairs I want to go into a new page on the form enter the client ID and have all of the client details appear on the screen according to the fields I have chosen to put in there, and then enter the repairer ID and have all of their details appear automatically also.

I then want to put a section at the bottom to have the details of the equipment that they have dropped to us on this occasion.

I am not sure if I need to do this in sub forms or if it can all be done on one screen.

As I said at the moment it is actually working it is just that it is changing the value of the client number when I enter the client number. I don't want to be adding new clients on this screen as only a fraction of there details are here. I just want it to be a look up.

Does this help more.

As I said I am going in circles with this so I appologise for my previous unclear posts.

Thankyou for your time in answering my queries.

Regards

Jodi

 

[jhsurti]

Try putting the ClientID field in the form header section. And then query the recordset to show the details of the relevant client in the details section. This will not change ur client ID.
U can use a wizard to do this initially and then make changes.
If u need more help, then post me the database with ur version of the form in question.

 

[soundsfishy]

see the attached

I think what u are looking many in one of the samples on find a customer and having their details autofill on a form.

just start typing and you will see who the name appears.

 

[jodilees]

Have attached.

The form I am talking about is tblclient. It is still very much in draft format as I wanted to get it working before i make modifications to it.

From here I also need to add similar information from the Repairer table.

I will then create other fields that I have not yet set up a table for.

Jodi

 

[soundsfishy]

see the attached

I think what u are looking many in one of the samples on find a customer and having their details autofill on a form.

just start typing and you will see who the name appears.

 

[jodilees]

Yes that is exactly what I am looking for, but I need to have two sets of this on the one form.

One for clients and one for repairers.

What is the best way to achieve that?

Jodi

 

[soundsfishy]

Im using access97 at work but at home I have A2000.

Did you want the repairs form within the Clients form to autofill when a client is selected or are you going to select a repairer to auto fill just like the customer details do.

I'll have a look at home and get back to you tomorrow.

 

[jodilees]

I think I want to be able to retrieve the information from the Customer number as opposed to the name.

We have divisions of companies that we deal with where they all have the same name and the only distinction is 3 letters at the end of a 50 letter name.

Regards

Jodi

 

[jodilees]

I want both of them to autofill from each different code being entered.

Thanks heaps.

Regards

jodi