Auto populate form

[verschup]

I have made a database to make it able for different projectleaders to monthly update their project.

They open the form, and a query asks for their name so that they can see the information of their project.

How can I make it happen that if they want to add a new month to this overview they dont have to fill out again their name, projectname since that remains the same??

I have been searching over this for a week and I am really desperate

 

[spacepro]

Welcome to the forum!

Please post an example with the form and query.Then we can help you.
Thanks

Andy

 

[verschup]

example

Welcome to the forum!

Please post an example with the form and query.Then we can help you.
Thanks

Andy

I've forgot to put in the question for the name of the projectleader (in the query), but the idea is that in this example Frank wants to update his project frank 2 for februari and the only fields he have to fill out when he creates a new record in the form are update1 and update2. Same goes for Dave.

thanks in advance.

 

[neileg]

Try this. This uses linked tables and subforms. Open frmProjectHeader to see.

 

[verschup]

thanks all

I want to thank you all for your help, but seems like I've found an other (more complicated) sollution... i've started programming

I've just putted in this code under the button to update:

Private Sub Command13_Click()
On Error GoTo Err_Command13_Click

'Variables used to store default values
Dim strName As String
Dim strProject As String
Dim strDepartment As String

'Store default values
'TODO : Catch null values
strName = [Champion's Name]
strDepartment = [department]
strProject = [Project Name]

'Add new record
DoCmd.GoToRecord , , acNewRec

'Fill in default values
[Champion's Name] = strName
[department] = strDepartment
[Project Name] = strProject

Exit_Command13_Click:
Exit Sub

Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click

End Sub

It does the job

ciao

 

[neileg]

Yes, but it's the wrong solution. You are storing the same data over and over again. You need to do some research on normalisation of databases.

 

[verschup]

thx

Yes, but it's the wrong solution. You are storing the same data over and over again. You need to do some research on normalisation of databases.

Neil,

You've started me woundering if there wasn't an easier solution.
So I've tried it your way, and indeed, it's much better setting up the database as you sugested.... THANKS

 

[neileg]

Pleased to have set you on the right course!