Dropdown list drops in the wrong place

[parishpete]

I've created two dropdown lists on a form populated from two tables.



The left hand list drops down to the right of its combo box and the right hand list drops down to the left of its combo box. Both list dropdowns are wider than they need to be.

Is there any way of moving and resizing them so the ydrop directly beneath their respective combo boxes?

second question: the form allows input of a date, a surname from one list and a book title from a second list. The three elements form a record and my 'Next' button uses RecordsGoToNew to enter a new record clearing the three boxes. I want to add another button so that the same date and surname remain but a second title can be input to create another record?

I'm sure there is a simple way, it just eludes me.

any help welcome, Thanks. Pete

[RuralGuy]

The "List Width" property on the Format tab of the property sheet controls the width when in drop down.

[parishpete]

The "List Width" property on the Format tab of the property sheet controls the width when in drop down.

Thank you RuralGuy.

I have the list width sorted but the list still drops down off to one side of the combo box rather than directly underneath. I can't see a property to alter this.

Is there one?

Thanks

Pete

[RuralGuy]

I don't believe so. It is probably trying to not cover up something that "Access" feels is important. If you move the control, does that anomoly change?

[parishpete]

I don't believe so. It is probably trying to not cover up something that "Access" feels is important. If you move the control, does that anomoly change?

Thank you again. The list was 3 lines to long display below the box. I had a reshuffle and it's in the right place now.

Regards and thanks

Pete

[RuralGuy]

Sounds like you're good to go. Are you ready to use the Thread Tools at the top of the thread and mark this thread as Solved?

[parishpete]

Sounds like you're good to go. Are you ready to use the Thread Tools at the top of the thread and mark this thread as Solved?

Nearly,

Just need guidance on the second question in my original post, although I only need to carry the completed name field forward to the next record entry as I've solved the date entry.

regards

Pete

[RuralGuy]

Have you considered using the Default Value? http://access.mvps.org/access/forms/frm0012.htm

[parishpete]

Have you considered using the Default Value? http://access.mvps.org/access/forms/frm0012.htm

I'll give a try in the morning though I only need to carry it forward once to the next record sometimes. The essence of the database is one person can loan 1 or 2 books at a time so the name of the borrower only carries forward if there two books borrowed

regards and thanks

Pete

[RuralGuy]

Since it is a default, it can easily be overwritten by the user. If you wanted, you could put the code behind you "new" button.

[parishpete]

Since it is a default, it can easily be overwritten by the user. If you wanted, you could put the code behind you "new" button.

Thanks for your help. I'm afraid I spent the morning without success. I tried inserting the field name as shown below and with a button, saving the record and running the code before New Record but the field in the combo box remains blank.

const cQuote="""" 'Thats two quotes me![Loaned to].DefaultValue = cQuote & me!Loaned to.Value & cQuote

Loaned to is just a number

Thank you for trying but It's a lot years since I was last under the hood of a database!

regards

Pete

[RuralGuy]

Copy and Paste the entire procedure you have been trying to use, please.

[parishpete]

Copy and Paste the entire procedure you have been tring to use, please.

I'm sorry but I deleted all the code I was using earlier.

In essence the the input on the form is simple and straight forward I think I'm just having a dumb day!

There are 3 elements to each record; a person's number held in one table, a book number held in another table, and a date. The three elements are stored in a third table as a loan record. Date can be ignored, any entries are only made once per month and the 'save' button uses Date() to put today in.

the two numbers are selected from the two drop down lists on the form from the 2 tables. Having selected the numbers the 'save' button puts in the date, saves the record, runs your code as I described in the last post, and then goes to new record.

What I had hoped is the combo box for person would show the last number entered and the book box be empty. But it was not to be!

The field that holds the number I want to carry forward is called [Loaned to]

Best I can give I'm afraid

Many thanks for your paitience and guidance

Pete

[RuralGuy]

So the "Save" button no longer has any code in its Click event?

[parishpete]

So the "Save" button no longer has any code in its Click event?

All it has now is:

RunMacro (to put in today's date)
and
RunMenuCommand 'SaveRecord'

A second button handles New record

regards

Pete