Need help asap

[ysfpsu]

This seems like a mediocre problem but I can't think of any way of making it work. I have a table with a bunch of fields in it and one of the fields is called 'user'. Now all the other values in the fields remain pretty much the same except the User name. I want so when I try entering a new record using a form, all the fields are already filled except the 'User' field, thus allowing me to just keep filling the table up with different user names while not having to fill up the other fields.
Any help would be awesome.
Thank you

 

[KeithIT]

Create a command button that creates a new record and then fills in the values of the fields:

Me.Field1.Value = "Value" (if it is a string value)
Me.Field2.Value = "Value2"
etc.

Does that help?

 

[Maddd0ggg]

ysfpsu

Set up your form with the corresponding table. For those fields that remain constant, select properties {data} tab and set the InPut Mask and Default Values for each of your fields. Leave the USER ID blank so you can fill that in. This will allow you to type over any of your predefined field values for any exceptions. Every record you produce should keep all of the static fields the same as you type in the User Value.

Hint: to automatically go to the user field each time set the form tabs so the user field is the first one you go to.

 

[ysfpsu]

Hey guys,
I tried both ur methods and they both seem to be working perfectly. Thanks a lot for your help.
Yusuf

 

[KeithIT]

Anytime, Maddd0ggg's method is most assuredly simpler than mine, and unless your needs change drastically in the future, will work just as well. Keep in mind that if you are working on a more dynamic form where you may need to have this option available for certain records but not others, you will need to use the VBA method, otherwise Maddd0ggg's reply is definately the way to go. Thanks!

 

[ScottGem]

This seems like a mediocre problem but I can't think of any way of making it work. I have a table with a bunch of fields in it and one of the fields is called 'user'. Now all the other values in the fields remain pretty much the same except the User name. I want so when I try entering a new record using a form, all the fields are already filled except the 'User' field, thus allowing me to just keep filling the table up with different user names while not having to fill up the other fields.
Any help would be awesome.
Thank you

While you got solutions they don't really address the underlying problem. You really seem to have a normalization problem. If you are repeating data in records where only one value is changing then your database is not properly normalized. User should be a subtable related to the other table using a foreign key.