Repeating data entry

[ath23]

Hi All,

I am having the same problem as my previous one. sorry to be repetitive, but because I am a Beginner in Access, the recommendations provided to me, I couldn't work out.

The Scenerio is again:
One data entry form to input responses to questions with the following fields:
1. Job Code (text)
2. Department
3. Interviewee Name
4. Interviewee Title

These fields are the same for all questions 1-15, but change with different department interviewed.

I wanted to create a command button that will:
1. Go to next record with the above fields automatcially filled in.

The recommendations were:
1. use control tag - not too sure how.....
2. use code build to build event..not sure how either..

It would be great to get some more clarifications. Thanks heaps.

 

[Talismanic]

You can put this in the last field of your form before the new record is started. It will work behind the controls On_Exit event.

With CodeContextObject

.JobCode.DefaultValue = """" & .JobCode & """"
.Department.DefaultValue = """" & .Department & """"
.IntervieweeName.DefaultValue = """" & .IntervieweeName & """"
.IntervieweeTitle.DefaultValue = """" & .IntervieweeTitle & """"


End With

Notice that I removed the spaces between your words in the field names. It is good programming practice to do it that way. It might work with the spaces as you had it but I'm not 100% sure. If you can not make the change you might try using the under score like this:

Job_Code
Interviewee_Name
Interviewee_Title

I think that will do it. Let me know if you have more questions.

 

[ath23]

Thanks Talismanic...

I think I am just pathetic because it didn't work for me....the syntax error keeps highlighting the last """".....

not sure where I am going wrong....Sorry to trouble you again!

 

[Talismanic]

ath23, can you strip all the vital information out of your database, compact it and send it to me. Send it to random@net-link.net.

If not just post your code here.

[This message has been edited by Talismanic (edited 01-17-2001).]