Form with fixed fields

[DenizBerkel]

Hi,
I'm very new to access and need to prepare a form for the colleagues. They want me to keep some fields fixed until they need to change them.
For example for the first 5 pages of the form they want the company name to be fixed...
Can it be done? I'm sure it can but I don't know how?
So any help would be much appreciated...

 

[rzw0wr]

Not sure I understand you completely.
First a form with more than 5 pages.
You need to explain further what you have so far.
Sound like you may be having table problems if you need over 5 pages of a single form.

Can you copy and paste your tables from relationship/design.

Dale

 

[DenizBerkel]

Thank you for your reply Dale.
Actually my form is just one page. It includes drop down answers for some questions. It will be filled in behalf of some providers and for some providers it has to be filled in maybe up to 5 times.
So I put a provider name field in the form. My friends don't want to choose the name of the provider from the drop down menu every time if they need to fill the form for the same provider for many times.
And it was just an example, I have more fields that will have the same information for several times.

So I want to keep those fields fixed to make the work easies for my colleagues.
I attached my work so far I've done.

Thank you very much for your time...
Regards
Deniz

 

[rzw0wr]

I downloaded your database.
In the single form you have there "Outcomes For Learners", you want the combo box "Providers" to remain the same after selection until changed by the user.
Correct.

Dale

 

[DenizBerkel]

Yes that is what I want to do...

 

[Mihail]

Providers_AfterUpdate
  Providers.DefaultValue = Providers
End Sub

 

[DenizBerkel]

Can you explain it a bit more? I couldn't decide where to write it.
Thank you
Deniz

 

[Mihail]

In your form you have a combo with name Providers (from what I understand).
So:
In Form Design window, select this combo.
In the Property Sheet window, under Event tab, identify the event named AfterUpdate.
Click the button with 3 dots (not sure if the word is "elipse" button).
In the popup window choose Code Bilder then press OK.
Access will write for you the first and the last line for the procedure for AfterUpdate event (and now I see my little mistake - SORRY)

Private Sub Providers_AfterUpdate
  Providers.DefaultValue = Providers
End Sub

 

[DenizBerkel]

Thank you very much for your help Mihail...
I think I'm doing something wrong. I want to use the form as data entery sheet and want to capture the data in the table. Is it how it is intented to work or is it the other way around?
Because first the code you gave me seemed to work but when I deleted the record from the table it started not to work.
Thank you again...
Deniz

 

[DenizBerkel]

I think I have found the answer of my question. Access works both ways.
Your code works very well now..
Thank you ever so much...
Deniz